Your 600GB database exists across 3 database files, each 200GB in size. It takes 12 hours to perform a full database backup. You decide to implement the following backup strategy : Full backup : 9am SundayFile 1 backup : 8pm Monday eveningFile 2 backup : 8pm Tuesday eveningFile 3 backup : 8pm Wednesday eveningFile 1 backup : 8pm Thursday eveningFile 2 backup : 8pm Friday eveningFile 3 backup : 8pm Saturday eveningTransaction log backups : Hourly, every day.DB suffers critical failure of the data file 3 at 1655hrs on Thursday causing widespread data loss and requiring a restore to recover. What would be the most efficient recovery procedure resulting in the least amount of data loss?

Questions by highvoltage

Showing Answers 1 - 1 of 1 Answers

srikanth tirunagari

  • May 25th, 2007
 

1) perform a tail log backup.
2) restore wednesday's File 3 backup with no recovery
3) restore all hourly transaction log backups in sequence taken after 8 pm on wednesday with no recovery
4) finally restore the tail log backup with recovery

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions