You work as a database administrator at ABC.com. You are working on a SQL Server 2008 R2
database called TestDB.
You have recently restored TestDB via a RESTORE Transact-SQL statement that includes the
CONTINUE_AFTER_ERROR, CHECKSUM, and RECOVERY arguments. You then noticed that
errors exist in the SQL Server logs for certain page restores.
You have received instructions to solve the issues as soon as possible.
Which of the following actions should you take?
A.
You should consider making use of a DBCC CHECKDB Transact-SQL statement that includes
the REPAIR_REBUILD and DATA_PURITY arguments.
B.
You should consider making use of a DBCC CHECKDB Transact-SQL statement that includes
the REPAIR_FAST and TABLOCK arguments.
C.
You should consider making use of a DBCC CHECKDB Transact-SQL statement that includes
the REPAIR_ALLOW_DATA_LOSS and DATA_PURITY arguments.
D.
You should consider making use of a DBCC CHECKDB Transact-SQL statement that includes
the REPAIR_ALLOW_DATA_LOSS and TABLOCK arguments.
Explanation:
.. explanation :
@see http://technet.microsoft.com/en-us/library/ms190952%28v=sql.105%29.aspx
.. remedy :
@see http://www.mssqltips.com/sqlservertip/2399/minimize-performance-impact-of-sql-server-dbcc-checkdb/