Sean McCown (MCM, MVP)
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 in SQL Server and a SQL Server MVP with 20 years of experience in high-end databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos and co-hosts the popular web show DBAs@Midnight. He is also an international speaker and the creator and author of the wildly popular (and free) Minion Maintenance tools and is President of MinionWare, LLC.