Microsoft
70-432 · Question #177
You maintain a SQL Server 2008 instance. You discover that the database named CityPowerLightDB presents data integrity problems. You perform a full database backup at 22:00 hours. The SQL Server…
The correct answer is A. Restore the corrupt pages from the full database backup. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance. You discover that the database named CityPowerLightDB presents data integrity problems. You perform a full database backup at 22:00 hours. The SQL Server instance experiences a power failure at 05:59 hours. No data modifications have occurred after the backup. When the database is online, you discover that some table data pages are corrupt. You need to completely repair the database in the minimum amount of time. What should you do?
Options
- ARestore the corrupt pages from the full database backup.
- BRestore the database from the full database backup.
- CUse the DBCC CHECKTABLE command along with the PHYSICAL_ONLY option.
- DUse the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS option.
How the community answered
(19 responses)- A74% (14)
- B5% (1)
- C16% (3)
- D5% (1)
Community Discussion
No community discussion yet for this question.