Tuesday, February 14, 2012

TempDB space needed to execute checkdb.

Sometime we may need to check the space required to execute CheckDB. We can run this query in live database because actually it is not running CheckDB Query. It is only checking the amount of space required to run this query. Use Below query to check this:

DBCC CheckDB('Database_Name') WITH EstimateOnly

DBCC CheckDB('DemoDatabase') WITH EstimateOnly

It will the below output:

No comments:

Post a Comment