Database Mirroring - sys.dm_db_mirroring_auto_page_repair

In this article

Returns a row for every automatic page-repair attempt on any mirrored database on the server instance. This view contains rows for the latest automatic page-repair attempts on a given mirrored 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)

6 = Irreparable. This indicates that an error occurred during page-repair attempt, for example, because the page is also corrupted on the partner, the partner is disconnected, or a network problem occurred. This state is not terminal; if corruption is encountered again on the page, the page will be requested again from the partner.