Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com has recently upgraded to SQL
Server 2008 R2.

You have been instructed to have an existing SQL Server 6.0 database, named ABCSales,
upgraded to an instance of SQL Server 2008 R2. You have to make sure that any questionable
pages in ABCSales can be identified at an early stage.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com has recently upgraded to SQL
Server 2008 R2.

You have been instructed to have an existing SQL Server 6.0 database, named ABCSales,
upgraded to an instance of SQL Server 2008 R2. You have to make sure that any questionable
pages in ABCSales can be identified at an early stage.
Which of the following actions should you take?

A.
You should consider configuring ABCSales to make use of the checksum page verify option.

B.
You should consider running the SQL Server Profiler on ABCSales.

C.
You should consider having the simple recovery model is configured for ABCSales.

D.
You should consider configuring ABCSales to make use of the torn page detection page verify
option.

Explanation:



Leave a Reply 0

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