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

DBCC CHECKDB WITH PHYSICAL_ONLY performs a streamlined check of page headers, record structure, and allocation pages - skipping expensive logical consistency checks. This reduces runtime significantly for large databases while catching corruptions like torn pages. The REPAIR options should never be run as part of routine maintenance, and DATA_PURITY adds checks that increase runtime.