DBCC CHECKDB Limits I

Question

Post reply

DBCC CHECKDB Limits I

Steve Jones - SSC Editor

SSC Guru

Points: 742466
More actions
June 29, 2026 at 12:00 am

#4868799

Comments posted to this topic are about the item DBCC CHECKDB Limits I

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

edmil SSC Veteran Points: 262 More actions · Answer 1

DBCC CHECKDB (master) WITH ALL_ERRORMSGS;

.

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

DBCC results for 'mssqlsystemresource'.

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker Msg 9667, State 1: Services analyzed: 3.....

.

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

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

This output suggests the resource database is checked when I run CHECKDB on master. What am I missing?

ewm2

Rune Bivrin SSCrazy Eights Points: 8750 More actions · Answer 2

Quoting from the article cited by Steve:

However, when DBCC CHECKDB is executed against the master database, a second CHECKDB is also run internally on the Resource database.

So I agree, the "correct" answer is wrong.

Just because you're right doesn't mean everybody else is wrong.

Steve Jones - SSC Editor SSC Guru Points: 742466 More actions · Answer 3

Agreed, and my apologies. Reworded the question and awarded points back.

dawryn SSCertifiable Points: 5762 More actions · Answer 4

Rune Bivrin wrote:

Quoting from the article cited by Steve:
However, when DBCC CHECKDB is executed against the master database, a second CHECKDB is also run internally on the Resource database.
So I agree, the "correct" answer is wrong.

Did you read one statement before?

Because the Resource database is modifiable only in single-user mode, the DBCC CHECKDB command can't be run on it directly.

This might be poorly reworded and taken as Correct answer, but IMHO there is no correct answer given in the options - is there any way to really run DBCC CHECKDB on Resource database and get an error on it?

There is no database 'Resource database' in master.sys.databases, database_id is unknown (Accessing the Resource Database: The ID of the Resource database is always 32767.), ...

This reply was modified 1 days, 8 hours ago by dawryn. Reason: indent
This reply was modified 1 days, 8 hours ago by dawryn.

Steve Jones - SSC Editor SSC Guru Points: 742466 More actions · Answer 5

The question was reworded after these comments (first2 ), so they are valid. The original question didn't say run it directly.