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://learn.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"