SQL Server Backup

VMware specific discussions

SQL Server Backup

Veeam Logoby jluce » Thu Apr 09, 2015 7:08 pm

I'm looking for confirmation on the following scenario that concerns SQL server using Veeam B&R 8.

My boss wants Veeam to run hourly backing up the SQL server, but once a week he would like a full backup to be done via a maintenance plan for the developers who can refresh the data on the test SQL servers. How would be best meet the plan outlined above?

Thanks!
jluce
Enthusiast
 
Posts: 25
Liked: 3 times
Joined: Wed Jan 14, 2015 2:23 am
Full Name: John Luce

Re: SQL Server Backup

Veeam Logoby Shestakov » Thu Apr 09, 2015 9:42 pm

Hello John,
You can make a backup job to run hourly(assuming job duration will not exceed an hour) using forward incremental method and full backup at weekends. You can also use backup window to run the job only during operation hours it will significantly decrease an overall size of backup jobs.
Thanks!
Shestakov
Veeam Software
 
Posts: 4861
Liked: 395 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: SQL Server Backup

Veeam Logoby Vitaliy S. » Thu Apr 09, 2015 10:02 pm

Do you want to do VM image or transaction logs backup of your SQL Server? Please review this link regarding option 2 > Transaction Log Settings: Microsoft SQL
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server Backup

Veeam Logoby jluce » Mon Apr 13, 2015 2:32 pm

They were looking to try to stay with VM image with the exception of just this one weekly backup performed on each of the databases so they can transmit that backup to the developers side of the house.
jluce
Enthusiast
 
Posts: 25
Liked: 3 times
Joined: Wed Jan 14, 2015 2:23 am
Full Name: John Luce

Re: SQL Server Backup

Veeam Logoby Shestakov » Mon Apr 13, 2015 4:29 pm

It`s possible to stay with images, but that means snapshot will be created hourly. If your database can handle it, just schedule a backup job to run hourly, as I suggested above.
However, if you need to backup SQL Server transaction logs, Veeam B&R will just copy the log backup files backed up by native SQL Server log backup process. Please review the hyperlink.
Thanks.
Shestakov
Veeam Software
 
Posts: 4861
Liked: 395 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 13 guests