Multiple choice technology databases

You have a 1TB SalesDB database running on SQL Server 2003 Enterprise Edition. You have noticed that the nightly DBCC CHECKDB ('SalesDB') job is starting to take too long, and you want to reduce the amount of time that the check will take. What command should you schedule to run nightly instead?

  1. DBCC CHECKDB ('SalesDB', REPAIR_ALLOW_DATA_LOSS)

  2. DBCC CHECKDB ('SalesDB', REPAIR_REBUILD)

  3. DBCC CHECKDB ('SalesDB') WITH PHYSICAL_ONLY

  4. DBCC CHECKDB ('SalesDB') WITH DATA_PURITY
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Using DBCC CHECKDB with the WITH PHYSICAL_ONLY option reduces check time on large databases by limiting checks to physical page structure, page integrity, and allocation. This skips resource-intensive logical checks. Options like REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD are used to fix errors.

Keep practicing — related questions