THE SQL Server Blog Spot on the Web

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

Rick Heiges

News about SQL Server and the SQL Server Community

Who's got your DB's back?

While I was reviewing one of the sessions from the PASS Community Summit using the streaming media on some new things in SQL Server 2008, I stumbled across a new reason to mirror.  The primary reason to mirror of course is availability and to give DBAs that warm fuzzy feeling that another up-to-date (or almost up-to-date if using Async mode) copy of your DB is ready to step into action at a moment's notice.  That has not changed in 2008, but another feature was been revealed.  It is the "Auto Page Repair" feature.  If the Principal encounters a page that is corrupted, it will ask the mirror to send of copy of that page for repair.  The mirror is of course replaying the transactions that are sent to it.  If the Mirror encounters a problem, it will request a copy of the page from the Principal.  This is not a new RAID level, but we could make up a new term like DB-RAID - -  ;-)  Again, it gives the DBA that warm fuzzy feeling that things will be OK. 

 

Published Friday, November 09, 2007 10:05 AM by RickHeiges

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

 

James Luetkehoelter said:

Great point Rick - yup, that's a big one to me. Personally I'm starting to feel that if the storage is available, mirroring should be a no-brainer decision...even if it is just to another box in the same building (better something than nothing).

November 10, 2007 10:46 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

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