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!
-
jeromyhensley
- Influencer
- Posts: 16
- Liked: never
- Joined: Jan 07, 2011 8:50 pm
- Full Name: Jeromy Hensley
- Contact:
-
Vitaliy S.
- VP, Product Management
- Posts: 27112
- Liked: 2719 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Production SQL Server Backup Strategies & Best Practices
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!
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!
Who is online
Users browsing this forum: Baidu [Spider], BaptisteT and 151 guests