http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Performance,Automation,High+Availability,Best+Practices&orTags=0Search results matching tags 'Performance', 'Automation', 'High Availability', and 'Best Practices'en-USCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/kevin_kline/archive/2011/06/27/pain-of-the-week-expert-s-perspective-performance-tuning-for-backups-and-restores.aspxMon, 27 Jun 2011 14:39:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36482KKline<p>First off - the Pain of the Week webcast series has been renamed.&nbsp; It's now known as <em>The Expert's Perspective</em>.&nbsp; 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!<br></p><p>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.</p> <p>Join my buddy Brent Ozar (<a href="http://brentozar.com/" title="One of the few, the proud, the MCMs" target="_blank">blog</a> |&nbsp;<a href="http://twitter.com/brento" title="Tro-lo-lo with BrentO" target="_blank">twitter</a>), a Microsoft Certified Master of SQL Server and good friend, as he reveals ways to make these critically important maintenance tasks run faster.</p> <p>You'll discover:</p> <ul><li>Why Instant File Initialization is so important for restores</li><li>How to use DMVs to check restore progress</li><li>How to find the bottleneck while you're backing up or restoring data</li></ul><p>Watch the recorded presentation at <a href="http://www.quest.com/events/ListDetails.aspx?ContentID=13358">http://www.quest.com/events/ListDetails.aspx?ContentID=13358</a>!</p><p>Enjoy!</p><p>-Kev</p> <div><span style="font-family:'Times New Roman';"> <a href="http://twitter.com/kekline" title="C'mon. You know you want to!" target="_blank">Follow me on Twitter at kekline</a></span></div> <div><span style="font-family:'Times New Roman';"> More content at&nbsp;<a href="http://kevinekline.com/">http://KevinEKline.com</a> </span></div>