You work as a database administrator at Domain.com. You are working on a SQL Server 2005
database called TestCont and are using a Transact-SQL script to restore TestCont. The Transact-SQL script is as follows:
RESTORE DATABASE TestCont
FROM contracts_bu_device
WITH CONTINUE_AFTER_ERROR, CHECKSUM, RECOVERY
However, after the restore there were still errors in some page restores in the SQL Server logs.
You have received instructions to repair the database pages as soon as possible.
What should you do?
A.
You should consider adding the following:
DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS
B.
You should consider adding the following:
ALTER DATABASE Contracts SET TORN_PAGE_DETECTION ON
C.
You should consider adding the following:
ALTER DATABASE Contracts SET TRUSTWORTHY ON
D.
You should consider adding the following:
DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH TABLOCK