Veeam B&R and SQL server backups

Hyper-V specific discussions

Veeam B&R and SQL server backups

Veeam Logoby Perry » Sun Jan 08, 2017 6:52 pm

Currently using BackupExec and looking to switch to Veeam B&R.

BackupExec has this problem where if a full VM backup is performed (time wise) between a full SQL DB backup and a differential SQL DB backup on the same machine, the SQL backup chain set would get broken and the SQL DB could not be restored from that set until the set was reset on the next full SQL backup. This has to do with the fact that both backup types use VSS and somehow they affected each-other.

This was very annoying and limited our backup options tremendously. Does Veeam have the same problem? Is this a VSS limitation or did BackupExec do it wrong?

And are there any other negative interactions with Veeam B&R I should keep in mind when separately backing up the VM hosting SQL server and the SQL database on the same machine?
Perry
Enthusiast
 
Posts: 43
Liked: never
Joined: Mon Jan 02, 2017 10:19 pm
Full Name: Perry

Re: Veeam B&R and SQL server backups

Veeam Logoby Vitaliy S. » Sun Jan 08, 2017 8:52 pm

Hi Perry,

Did you use separate approaches to back up up your SQL Server VM? Since Veeam B&R can control both full and incremental backups of your SQL Server, it shouldn't be an issue. Please take a look at this User Guide page for more info on how SQL Server backup works > How Microsoft SQL Server Logs Backup Works

Let me know if that answers your question.
Vitaliy S.
Veeam Software
 
Posts: 19974
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam B&R and SQL server backups

Veeam Logoby Perry » Mon Jan 09, 2017 11:41 am

Yea, I am not talking so much about how Veeam backs up SQL since I have SQL itself do that through its own backup commands. But I am talking about how Veeam backing up the VM that hosts that SQL database might interfere with it.
Perry
Enthusiast
 
Posts: 43
Liked: never
Joined: Mon Jan 02, 2017 10:19 pm
Full Name: Perry

Re: Veeam B&R and SQL server backups

Veeam Logoby Vitaliy S. » Mon Jan 09, 2017 1:02 pm

Ok, in this case please take a look at the existing topic with the same question > SQL Backup without processing the logs
Vitaliy S.
Veeam Software
 
Posts: 19974
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam B&R and SQL server backups

Veeam Logoby Perry » Tue Jan 10, 2017 6:41 pm

So use the COPY_ONLY mode. But if I don't have the "Enable Application-Aware processing" check box selected then I assume the default is not to do any processing in which case COPY_ONLY mod is used by default, correct? So I don't have to set this if unchecked.
Perry
Enthusiast
 
Posts: 43
Liked: never
Joined: Mon Jan 02, 2017 10:19 pm
Full Name: Perry

Re: Veeam B&R and SQL server backups

Veeam Logoby Vitaliy S. » Tue Jan 10, 2017 7:55 pm

Yes, that's correct, but I would still recommend to use COPY_ONLY and AAP mode to back up your VM.
Vitaliy S.
Veeam Software
 
Posts: 19974
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam B&R and SQL server backups

Veeam Logoby Perry » Thu Jan 12, 2017 9:03 pm

So you're saying, enable the "Enable Application-Aware processing" and then select COPY_ONLY for that VM? Why would I want to enable it only to disable it at a lower level. What else am I getting from enabling it?
Perry
Enthusiast
 
Posts: 43
Liked: never
Joined: Mon Jan 02, 2017 10:19 pm
Full Name: Perry

Re: Veeam B&R and SQL server backups

Veeam Logoby Vitaliy S. » Fri Jan 13, 2017 1:11 pm

You start using VSS writers and providers to prepare your VM for application-consistent backups.
Vitaliy S.
Veeam Software
 
Posts: 19974
Liked: 1145 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 1 guest