6

Can a full DBCC CHECKDB operation be safely offloaded to an AG secondary server? Would be nice to not have this overhead on the primary server.

SQL2019

1 Answer 1

6

There are risks for not running DBCC CHECKDB on the Primary Replica. Brent Ozar goes into details in his article Can I Offload DBCC CHECKDB To Another Server?, but one big reason being you should check for database corruption on the same server where you take your backups to ensure your backups aren't corrupt as well. Furthermore, it's actually best practice to run DBCC CHECKDB on all production servers that have the potential to become the Primary Replica, as discussed in Where to Run DBCC on Always On Availability Groups.

For some ideas on optimizing DBCC CHECKB performance, you can also see this Brent Ozar Article: 3 Ways to Run DBCC CHECKDB Faster.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.