2

Do Microsoft SQL Server 2012 Enterprise regular databases (without AlwaysOn) have Automatic Page Repair in any manner?

I know from below, by incorporating AlwaysOn, Secondary replicas receive Automatic Page repair. Just inquiring if this feature is available to SQL Server databases without Alwayson?

Per MSDN documentation https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-2017 , it states

"Each availability replica tries to automatically recover from corrupted pages on a local database by resolving certain types of errors that prevent reading a data page. If a secondary replica cannot read a page, the replica requests a fresh copy of the page from the primary replica. If the primary replica cannot read a page, the replica broadcasts a request for a fresh copy to all the secondary replicas and gets the page from the first to respond"

5

Yes, if the database participates in Database Mirroring.

But otherwise, no. If you want page repair, you'll need to do it manually with page level restores.

  • 3
    Just to clarify, page repair isn't "available to" mirror or secondary. The reason automatic page repair can work is that there is still an un-broken page in the secondary before the broken page from the primary has been copied over. The process doesn't fix the secondary, the process takes the still-good page from the secondary and applies it to the primary, replacing the broken page there. If you don't have a secondary (e.g. you're not using mirroring or AGs), you have to go get the page yourself, as the link describes. – Aaron Bertrand Jun 15 '18 at 15:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy