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 »

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.
VP, Product Management
Posts: 27371
Liked: 2799 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. »

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: Bing [Bot], Google [Bot], stevetNOVUS and 160 guests