Sql-server – MSSQL Mirroring + db integrity check

dbcc-checkdbmirroringsql server

Is it necessary to do a database integrity check (DBCC check) on mirrored databases?

https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/automatic-page-repair-availability-groups-database-mirroring?view=sql-server-2017

Automatic page repair is supported by database mirroring and by Always
On availability groups. After certain types of errors corrupt a page,
making it unreadable, a database mirroring partner (principal or
mirror) or an availability replica (primary or secondary) attempts to
automatically recover the page.

What is you best practice?

Best Answer

No, that's one of the main benefits of mirroring is the page repair; it checks for corruption and then tries to address it if it finds any.

Related Question