Discussions specific to the VMware vSphere hypervisor
Post Reply
jluce
Enthusiast
Posts: 25
Liked: 3 times
Joined: Jan 14, 2015 2:23 am
Full Name: John Luce
Contact:

SQL Server Backup

Post by jluce » 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!

Shestakov
Veeam Software
Posts: 6910
Liked: 700 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: SQL Server Backup

Post by Shestakov » 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!

Vitaliy S.
Product Manager
Posts: 22862
Liked: 1538 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server Backup

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

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

Re: SQL Server Backup

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

Shestakov
Veeam Software
Posts: 6910
Liked: 700 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: SQL Server Backup

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

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 23 guests