You need to ensure the early detection of suspect pages in the database

You manage a SQL Server 2008 instance. You upgrade a SQL Server 7.0 database to the
SQL Server instance.
You need to ensure the early detection of suspect pages in the database.
What should you do?

You manage a SQL Server 2008 instance. You upgrade a SQL Server 7.0 database to the
SQL Server instance.
You need to ensure the early detection of suspect pages in the database.
What should you do?

A.
Turn on the TRUSTWORTHY database option for the database.

B.
Set the database compatibility level option to 10 for the database.

C.
Set the PAGE_VERIFY database option to CHECKSUM for the database.

D.
Set the PAGE_VERIFY database option to TORN_PAGE_DETECTION for the model
database.



Leave a Reply 0

Your email address will not be published. Required fields are marked *