Microsoft
70-450 · Question #124
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…
The correct answer is C. Set the database recovery model to FULL. D. Set the PAGE_VERIFY database option to CHECKSUM. See the full explanation below for the reasoning.
Question
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.)
Options
- ARebuild the nonclustered indexes.
- BRebuild the clustered indexes and heaps.
- CSet the database recovery model to FULL.
- DSet the PAGE_VERIFY database option to CHECKSUM.
- ESet the PAGE_VERIFY database option to TORN_PAGE_DETECTION.
- FExecute the DBCC CHECKDB command by using the DATA_PURITY option.
How the community answered
(38 responses)- A3% (1)
- B5% (2)
- C76% (29)
- E3% (1)
- F13% (5)
Community Discussion
No community discussion yet for this question.