Comprehensive data protection for all workloads
Post Reply
jeromyhensley
Influencer
Posts: 16
Liked: never
Joined: Jan 07, 2011 8:50 pm
Full Name: Jeromy Hensley
Contact:

Production SQL Server Backup Strategies & Best Practices

Post by jeromyhensley » Mar 04, 2011 8:48 pm

I've been looking for tips, advice, best practices on backing up Production SQL Servers utilizing Veeam. If there are threads on this topic plz direct me to them.

Basically our old method was to do full DB backups aka BAKs and TL backups utilizing SQL servers built-in backup and store procedures. Anyone out there willing to share what their SQL server backup strategies are with Veeam?

Much Appreciated!

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

Re: Production SQL Server Backup Strategies & Best Practices

Post by Vitaliy S. » Mar 04, 2011 11:06 pm

Hello Jeromy,

Well...the best practice would be to enable "Application-aware image processing", in this case your SQL backups would be transaction-consistent. Besides, if you're using Full Recovery mode on your SQL Servers, you may also choose to truncate transaction log files on successful backup jobs. See User Guide (page 65) for further reading.

Hope it helps!

Post Reply

Who is online

Users browsing this forum: oleg.feoktistov, unsichtbarre, wishr and 64 guests