Availability for the Always-On Enterprise
Post Reply
turnerr12
Influencer
Posts: 12
Liked: never
Joined: Jan 14, 2010 11:59 am
Full Name: Ric Turner
Contact:

Backing up the Veeam server

Post by turnerr12 » 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

Gostev
Veeam Software
Posts: 22995
Liked: 2890 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backing up the Veeam server

Post by Gostev » 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.

Ace T
Enthusiast
Posts: 35
Liked: never
Joined: Dec 02, 2009 8:32 am
Full Name: Amit Panchal
Contact:

Re: Backing up the Veeam server

Post by Ace T » 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 ?

Gostev
Veeam Software
Posts: 22995
Liked: 2890 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backing up the Veeam server

Post by Gostev » 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:

BearHuntr
Enthusiast
Posts: 26
Liked: 3 times
Joined: Jan 01, 2006 1:01 am
Contact:

Re: Backing up the Veeam server

Post by BearHuntr » Feb 22, 2010 4:02 pm

We use the Free version of SQL Backup and FTP from http://sqlbackupandftp.com/. It works great!

murda
Enthusiast
Posts: 38
Liked: never
Joined: Dec 18, 2009 10:05 am
Full Name: murda
Contact:

Re: Backing up the Veeam server

Post by murda » 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.

Gostev
Veeam Software
Posts: 22995
Liked: 2890 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Backing up the Veeam server

Post by Gostev » 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.

withanh
Expert
Posts: 262
Liked: never
Joined: Jul 21, 2009 3:19 pm
Full Name: Darhl
Location: Pacific Northwest
Contact:

Re: Backing up the Veeam server

Post by withanh » 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

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Bryan.simmons, Exabot [Bot], foggy, KennethCrowl, Wad4iPod and 67 guests