DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB1. As part of your backup method of ABC_DB1,
you do a Full backup every Sunday at 01:00, you do a differential backup weekdays at 22:00, and
you do transactional log backup weekdays at 08:00; 12:00 and 16:00.
You have received notification that the user database data files have failed on Thursday at 15:00.
You need to ensure that ABC_DB1 are retrieve as quickly as possible with as small as possible
amount of data loss.
What steps should you take? Use only steps that apply.
Explanation:
Your hints contain an error :
In fact only the last one of the Differential Backups is really needed (here : Wednesday).
Please remove the Differential Backups at Monday and Tuesday from your answer.
see http://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/
Thank you Yuri. I thought I were crazy.