The Backup Tune-up [DBA-416]

Speaker: Sean McCown

Duration: 75 minutes

Track: Enterprise Database Administration and Deployment

Have you ever gotten tired of your 1TB database taking 4+ hrs to backup?  Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB?  Well now you don’t have to worry about that anymore.  I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query.  Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down 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 15yrs to tune my backups and I’ve had great success with it.


 

 

 
 

Why Attend?


■ All SQL Server. All the time

■ Over 170 technical sessions

■ Dr. David DeWitt Keynote

■ 2 days of Pre-Con Seminars

■ Networking with MVPs, experts, and peers

■ Face-to-face support with     Microsoft CSS and SQLCAT

■ Ask the Experts Pods
 

 
 
 

 

cage-aids
cage-aids
cage-aids
cage-aids