You need to restore the Finance database by ensuring minimal data loss

You maintain a SQL Server 2008 instance that contains a database named Finance.
The most recent full backup was taken at 13:00 horns, a differential backup was taken at
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The
backups and the database snapshots are stored on a different disk from the database files.
The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?

You maintain a SQL Server 2008 instance that contains a database named Finance.
The most recent full backup was taken at 13:00 horns, a differential backup was taken at
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The
backups and the database snapshots are stored on a different disk from the database files.
The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?

A.
Restore the full backup.

B.
Restore the database snapshot from 16:00 hours.

C.
Restore the database snapshot from 17:00 hours.

D.
Restore the full backup and the differential backup.



Leave a Reply 0

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