Wednesday, May 17, 2017

CHECKDB on Resource Database


As we know resource database is hidden database, we can't access it directly from SSMS
One might be thinking how we can check the consistency errors on resource database.

If we cleanly observe, when we run DBCC CHECKDB on MASTER database we will get below


CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'mssqlsystemresource'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


DBCC CHECKDB on master database also runs checkdb on resource database also.