PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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