You are managing your company database. You manage a SQL Server 2005 database
called ContractTEST, which is down.
You operate a restore by using the following Transact-SQL script. RESTORE DATABASE
ContractTESTFROM contracts_bu_deviceWITH CONTINUE_AFTER_ERROR,
CHECKSUM, RECOVERY After the restore, the SQL Server logs show errors in some page
restores.
What you should do is to repair the database pages, which are down, and facilitates repair
by using the fastest method.
Which is the correct answer?
A.
You should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS)
WITH NO_INFOMSGS
B.
You should add code: ALTER DATABASE Contracts SET TORN_PAGE_DETECTION
ON
C.
You should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS)
WITH TABLOCK
D.
You should add code: ALTER DATABASE Contracts SET TRUSTWORTHY ON