Applies to: SQL Server (all supported versions)
Returns a row for every automatic page-repair attempt on any availability database on an availability replica that is hosted for any availability group by the server instance. This view contains rows for the latest automatic page-repair attempts on a given primary or secondary database, with a maximum of 100 rows per database. As soon as a database reaches the maximum, the row for its next automatic page-repair attempt replaces one of the existing entries.
The following table defines the meaning of the various columns:
|Column name||Data type||Description|
|database_id||int||ID of the database to which this row corresponds.|
|file_id||int||ID of the file in which the page is located.|
|page_id||bigint||ID of the page in the file.|
|error_type||int||Type of the error. The values can be:
-1 = All hardware 823 errors
1 = 824 errors other than a bad checksum or a torn page (such as a bad page ID)
2 = Bad checksum
3 = Torn page
|page_status||int||The status of the page-repair attempt:
2 = Queued for request from partner.
3 = Request sent to partner.
4 = Page was successfully repaired.
5 = The page could not be repaired during the last attempt/ Automatic page repair will attempt to repair the page again.
|modification_time||datetime||Time of last change to the page status.|
Requires VIEW SERVER STATE permission on the server.