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
Example:
DBCC CheckDB('DemoDatabase') WITH EstimateOnly
It will the below output:
No comments:
Post a Comment