sys.dm_hadr_auto_page_repair (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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.

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Automatic Page Repair (Availability Groups: Database Mirroring)
suspect_pages (Transact-SQL)
Manage the suspect_pages Table (SQL Server)