Saturday, February 7, 2009

The First Real Post - Auto Page Repair in SQL 2008

Microsoft SQL Server 2008 Auto Page Repair with Mirroring

This feature is based on the fact that the principal and mirror databases are exactly the same. So, if a page becomes corrupt on the principal, SQL Server should be able to read the page from the mirror and use it to fix the principal. Similarly, if a page becomes corrupt on the mirror, the page can be read from the principal to fix up the mirror.

See http://www.sqlskills.com/blogs/paul/post/SQL-Server-2008-Automatic-Page-Repair-with-Database-Mirroring.aspx for the details.

No comments:

Post a Comment