What steps should you take?

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.

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.

Answer:

Explanation:

← Previous question

Next question →

Leave a Reply 2

yuri

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/

Thiago

Thank you Yuri. I thought I were crazy.