The Backup Tune-up for Speed
Have you ever gotten tired of your database taking hours to back up? Are you sick of your users breathing down your neck because the database restore is taking too long? Now you won't have to worry about that anymore. In this session, I show you some little-known tricks, methods, and trace flags you can use to tune your backups just like you would with a query. You'll learn about the backup "execution plan" and how to access it. Understanding how to tune the individual portions of your backup process will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15 years to tune my backups, and I’ve had great success.
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
- Capitol Area Central Texas Users of SQL Server 81 Recordings
- SQL Backup 6 Recordings