question

IgorGelin-0063 avatar image
0 Votes"
IgorGelin-0063 asked Cathyji-msft commented

Best practice on DBCC CHECKDB

Hi all,

Should we ever run DBCC CHECKDB against sql server system databases?

Thanks,

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @IgorGelin-0063

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

Hi,

Any update for this thread?

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

Yes. You should regularly run DBCC CHECKDB on master, model and msdb. They too can become corrupted if your hardware is having a bad day.

You could argue that since tempdb is being recreated when SQL Server restartes, it is less critical. Then again:
1) You may not restart SQL Server that often, and you get corruption in system tables, you will still have a problem.
2) And even if corruption is only in tempdb, it is still an indication that your hardware is wonky and needs inspection/replacement.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @IgorGelin-0063,

Yes, you should run it against master, model, msdb and tempdb, plus all your user databases.

Below is a good blog about DBCC CheckDB, suggest you reading it. It will make you better understand DBCC CheckDB.

DBCC CheckDB FAQ: Check for Corruption in SQL Server


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.