THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

Pain of the Week/Expert's Perspective: Performance Tuning for Backups and Restores

First off - the Pain of the Week webcast series has been renamed.  It's now known as The Expert's Perspective.  Please join us for future webcasts and, if you're interested in speaking, drop me a note to see if we can get you on the roster!

The bigger your databases get, the longer backups take. That doesn't really seem like a huge problem — until disaster strikes and you need to restore your databases as fast as possible.

Join my buddy Brent Ozar (blogtwitter), a Microsoft Certified Master of SQL Server and good friend, as he reveals ways to make these critically important maintenance tasks run faster.

You'll discover:

  • Why Instant File Initialization is so important for restores
  • How to use DMVs to check restore progress
  • How to find the bottleneck while you're backing up or restoring data

Watch the recorded presentation at http://www.quest.com/events/ListDetails.aspx?ContentID=13358!

Enjoy!

-Kev

More content at http://KevinEKline.com
Published Monday, June 27, 2011 10:39 AM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement