Categories
DBA

DBCC CHECKDB & READ ONLY DATABASES

DBCC CHECKDB & READ ONLY DATABASES:

Can you run a checkdb command on Read-only databases? If yes, does this get logged into boot page of the database? If checkdb finds an error can it fix on a read-only database?

These were some of the questions running through my mind as I manage some read-only databases in an SQL server which is mostly used for archiving and wanted to have the same level of checks and monitoring stuff we do an read write OLTP databases.