Backing up the Veeam server

Availability for the Always-On Enterprise

Backing up the Veeam server

Veeam Logoby turnerr12 » Fri Feb 19, 2010 8:51 am

Hi

We recently had an issue with Veeam B&R 4.1 that gave us the "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" error :x
Veeam Support told us we needed to uninstall and reinistall Veeam and also [install SQL Management Station and] delete the Veeam Database. This meant that all the jobs we had set up (60+ - one for each VM so that we can manually run each one) were all wiped out. :cry:
Is there any way that we can backup yp the Veaam server/database so that should this happen again we can roll the DB back to a working state?

Cheers
Ric
turnerr12
Influencer
 
Posts: 12
Liked: never
Joined: Thu Jan 14, 2010 11:59 am
Full Name: Ric Turner

Re: Backing up the Veeam server

Veeam Logoby Gostev » Fri Feb 19, 2010 11:08 am

Ric, yes you can backup Veeam SQL database just like any other SQL database, it is no special. For example, you can use backup capabilities which are built into the SQL management studio. Thank you.
Gostev
Veeam Software
 
Posts: 22056
Liked: 2564 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backing up the Veeam server

Veeam Logoby Ace T » Fri Feb 19, 2010 11:22 am

We use a 3rd party product to backup SQL databases. I have tried to connect to our Veeam servers but am not getting a connection. I have enabled Named Pipes and also TCP/IP Protocols under SQL Server 2005 Config Manager but this has not worked. Can you help ?
Ace T
Enthusiast
 
Posts: 35
Liked: never
Joined: Wed Dec 02, 2009 8:32 am
Full Name: Amit Panchal

Re: Backing up the Veeam server

Veeam Logoby Gostev » Fri Feb 19, 2010 12:21 pm

Amit, for this issue you may want to open support call with that other backup product vendor instead... I am afraid we will not be able to help you in troubleshooting SQL connectivity issues in 3rd party backup product :wink:
Gostev
Veeam Software
 
Posts: 22056
Liked: 2564 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backing up the Veeam server

Veeam Logoby BearHuntr » Mon Feb 22, 2010 4:02 pm

We use the Free version of SQL Backup and FTP from http://sqlbackupandftp.com/. It works great!
BearHuntr
Enthusiast
 
Posts: 26
Liked: 3 times
Joined: Sun Jan 01, 2006 1:01 am

Re: Backing up the Veeam server

Veeam Logoby murda » Tue Feb 23, 2010 1:48 pm

I do it in this way.

I made bat file to dump the sql db towards another disk.

@echo off
net stop MSSQL$VEEAM
robocopy /S /ZB "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1" "E:\Backup SQL database"
net start MSSQL$VEEAM


After that I made an Rsync schedule to backup this E:\ drive towards my NAS.
I also setup BU EXEC to backup the E:\ drive on this machine.

E drive is also used for Veeam Backups.
murda
Enthusiast
 
Posts: 38
Liked: never
Joined: Fri Dec 18, 2009 10:05 am
Full Name: murda

Re: Backing up the Veeam server

Veeam Logoby Gostev » Tue Feb 23, 2010 2:01 pm

Thanks everyone for sharing your own how-tos! This should be very useful for future readers having the same question.
Gostev
Veeam Software
 
Posts: 22056
Liked: 2564 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backing up the Veeam server

Veeam Logoby withanh » Wed Feb 24, 2010 2:06 pm

I don't do anything special other than back up my Veeam VM like any other VM. I use SAN/NBD with automatic rollover, you CANNOT back it up in VA mode, it will crash your Veeam server and put the disks into persistent mode and set to ignore changes. Then when you power down the machine it reverts back. I've had this happen to me twice and have lost a month the first time and 2 weeks the second time until I figured out what the issue was.
For every expert there is an equal and opposite expert - Arthur C Clarke's Fourth Law
withanh
Expert
 
Posts: 262
Liked: never
Joined: Tue Jul 21, 2009 3:19 pm
Location: Pacific Northwest
Full Name: Darhl


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: No registered users and 32 guests