You administer a SQL Server 2008 infrastructure. You plan to upgrade a Microsoft SQL
Server 2005 instance to SQL Server 2008 by using an in-place upgrade. All user databases
use the simple recovery model and have the PAGE_VERIFY option turned off. You need to
ensure that the database engine can identify I/O path errors and memory corruptions for the
data in tables. Which two actions should you perform before the upgrade? (Each correct
answer presents part of the solution. Choose two.)
A.
Rebuild the nonclustered indexes.
B.
Rebuild the clustered indexes and heaps.
C.
Set the database recovery model to FULL.
D.
Set the PAGE_VERIFY database option to CHECKSUM.
E.
Set the PAGE_VERIFY database option to TORN_PAGE_DETECTION.
F.
Execute the DBCC CHECKDB command by using the DATA_PURITY option.