PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products
whose recovery model is set to full for Company.com. The Products database?

backup method is listed below:The information reserve on different disks. The hard disks which include the user database data files are reported to have failed at 17:00 hours on Wednesday. You should make sure that Products database could be saved by minimal data loss.

Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should recovery the full backup taken on Sunday. And then recovery the differential
backup taken on Wednesday.

B.
You should recovery the full backup taken on Wednesday. And then recovery the differential
backup taken on Sunday.

C.
You should recovery the full backup taken everyday. And then recovery the differential backup
taken on Wednesday.

D.
You should back up the transaction log and recovery the full backup taken on Sunday and
then recovery differential backup taken on Tuesday. And recovery the


Leave a Reply