Comprehensive data protection for all workloads
Post Reply
SebSpi
Influencer
Posts: 17
Liked: 1 time
Joined: Apr 13, 2016 2:42 pm
Full Name: Sebastian S
Contact:

Best Practice within Veeam for SQL Server 2012 backup

Post by SebSpi »

Hello guys,

I was wondering if there is a document for best practices for SQL Server or tipps. We have a backup Job that runs for almost a year by now, but I should look for best practices within Veeam Backup & Replication, Options that the staff of Veeam would recommend.

I looked through the Forum and found this link:
veeam-backup-replication-f2/is-there-a- ... hilit=best practice SQL
Sadly I couldn't make much out of it, because I couldn't find the best practice guide in solution architecture and I don't know if this is the right Whitepaper I am searching for.

Then I found this Whitepaper:
http://veeampdf.s3.amazonaws.com/guide/ ... ke2qyJM%3D
which looked promising at the beginning but when I think about best practices I always think of a solution or recommendation, but this pdf just explains the different Options without giving a clear recommendation which Option should be used. It was helpful in understanding the General Options, but still it Looks like there is no best practice provided by Veeam itself.

Following Options are selected right now:

Storage:
Backup proxy -> Automatic Selection
Restore Points to Keep -> 7
Configure secondary destinations for this Job is enabled

Storage Advanced Options:
Backup Mode -> Incremental without synthetic full backups
Active full backup: Enabled every first monday monthly
Data reduction: all three Options enabled
Compression Level: optimal / Local target
Changed block tracking: both Options within the tab vSphere enabled

Guest Processing:
Enable application-aware processing: enabled
Applications -> Require successful processing
Transaction Logs -> Process Transaction logs with this Job
SQL -> Truncate logs
Oracle -> Archived Logs: do not delete
Schedule: daily

Options I didn't mention were disabled. So far I only know that Application Aware processing must be enabled and that the recommended Options also work with SQL Server. What gives me some headaches are the truncation logs. One Option is that Veeam does the backup for us and the other Option is that we can do our own SQL backups. I bet the better Option is letting Veeam handle this.
What should be changed, what have I missed?
DaveWatkins
Veteran
Posts: 370
Liked: 97 times
Joined: Dec 13, 2015 11:33 pm
Contact:

Re: Best Practice within Veeam for SQL Server 2012 backup

Post by DaveWatkins »

To have Veeam backup your logs, Under Guest Processing where you have SQL -> Truncate Logs, change it too "Backup Logs periodically". That'll open up some other options although in most cases the defaults should be right. This will give you transaction level restore capability
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Best Practice within Veeam for SQL Server 2012 backup

Post by PTide »

Also make sure your database is in a Full or Bulk-logged recovery mode. Here is more info on how SQL Transaction Log backup works.

Thanks
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Best Practice within Veeam for SQL Server 2012 backup

Post by foggy »

Another useful thread, however, basically, all you need is to enable application-aware image processing and decide whether you want to backup logs via Veeam B&R or use some native/external application for that.
Post Reply

Who is online

Users browsing this forum: bct44, Bing [Bot], Google [Bot], orb and 164 guests