embed embed share link link comment comment

Embed This Video close
Share This Video close
bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark bookmark
embed test
Rate This Video embed
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...
Tags For This Video tags
rate rate tags tags related related lights lights

The Backup Tune-up for Speed

Speaker:

Sean McCown (MCM, MVP)

Abstract:

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.

Bio:

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.

Recorded At:

Austin SQL Server User Group

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>