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.