You need to completely repair the database in the minimum amount of time

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?

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?

A.
Restore the corrupt pages from the full database backup.

B.
Restore the database from the full database backup.

C.
Use the DBCC CHECKTABLE command along with the PHYSICAL_ONLY option.

D.
Use the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS
option.



Leave a Reply 0

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