DBCC CHECKDB temp database

pma111
pma111 used Ask the Experts™
on
is it a recommended best practice to run DBCC CHECKDB over tempDB in SQL? Or only really user databases? Is there any logic why an admin would run DBCC CHECKDB over every database but tempDB?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
yes, you should run CheckDB against all databases
Associate Principal Engineer
Top Expert 2014
Commented:
Hello,

There is one beautiful question answer session on DBCC CHECKDB command.

Please go though it HERE .

Author

Commented:
do DBCC CHECKDB and CHECKSUM page verifacation check for the same thing? Or are they doing different types of checks?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial