You work as a Database Administrator (DBA) at ABC.com. The infrastructure includes servers running
Windows Server 2008 R2 and Microsoft SQL Server 2012. The company uses several custom
applications that store data in databases on the Microsoft SQL Server 2012 servers.
A full backup of all databases is taken every night at midnight.
A differential backup of all databases is taken on the hour every hour starting at 3am until the last
backup at 11pm.
A log backup is taken every 15 minutes for databases configured with the Full Recovery Model.
One application named ABCApp1 stores data in a database named ABCApp1DB.
ABCApp1DB is configured with the Simple Recovery Model. ABCApp1DB fails at 3:25am.
You discover that the last differential backup of ABCApp1DB failed.
You need to restore ABCApp1DB from backup as quickly as possible and minimize data loss.
Which of the following steps should you perform to restore ABCApp1DB? (Choose one or more
answers).
A.
Restore the latest full backup.
B.
Restore the latest differential backup
C.
Restore the latest log backup
D.
Restore each differential backup taken since the last full backup.
E.
Restore each log backup since the last full backup.
A
It should be A + B,
Because we do have the latest differential backup which was taken at 10 PM. The failed backup is the last backup taken on 11 PM .Therefore, we should restore the latest full backup and the latest differential backup
but “full backup of all databases is taken every night at midnight.” , so the answer still is only A
You discover that the last differential backup of ABCApp1DB failed.
The last full backup was taken at 12:00 am. The latest differential backup was taken at 10:00 pm. We only need to perform the last full backup.
Full Backup – A