Best Practice within Veeam for SQL Server 2012 backup

[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]

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]

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]

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.