PrepAway - Latest Free Exam Questions & Answers

which contains the database files at 17:03. so what should you do to recover the Funds database while reducing

You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named Funds. At 14:00 every day, the latest full backup was performed, and at 15:00, a differential backup was performed. At 16:00 and 17:00, database snapshots were created. Both the backups and the snapshots are stored on a different disk from the database files. The hard disk which contains the database files at 17:03. so what should you do to recover the Funds database while reducing the data loss?

PrepAway - Latest Free Exam Questions & Answers

A.
You should recover the full backup.

B.
You should recover the database snapshot from 17:00 hours.

C.
You should recover the database snapshot from 16:00 hours.

D.
You should recover the full backup and the differential backup.


Leave a Reply