What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1.
The backup method of CK_DB1 is follows:
* Full backup, Sunday at 01:00
* Differential backup, weekdays at 22:00
* Transaction log backup weekdays at 08:00; 12:00 and 16:00

You have received notification that the user database data files have failed on Wednesday at
17:00. You need to ensure that CK_DB1 are saved with the minimal amount of data loss.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1.
The backup method of CK_DB1 is follows:
* Full backup, Sunday at 01:00
* Differential backup, weekdays at 22:00
* Transaction log backup weekdays at 08:00; 12:00 and 16:00

You have received notification that the user database data files have failed on Wednesday at
17:00. You need to ensure that CK_DB1 are saved with the minimal amount of data loss.

What should you do?

A.
You should consider recovering the full backup taken daily and thereafter recover the
differential backup taken on Wednesday.

B.
You should consider recovering the full backup on Wednesday and thereafter recover the
differential backup taken on Sunday.

C.
You should consider recovering the full backup on Sunday and thereafter recover the
differential backup taken on Wednesday.

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



Leave a Reply 0

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