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+B
You have also a differential backup. This is possible with simple recovery model.
https://www.mssqltips.com/sqlservertutorial/4/sql-server-simple-recovery-model
https://technet.microsoft.com/nl-nl/library/ms191164%28v=sql.105%29.aspx
Yeah BUT!!
Read the question first !! It says the the differential backup failed -_-‘
A
E
A
The answer should be A + B, because we have the last differential backup which was taken at 10 pm, it is possible to restore that by simple recovery model. otherwise you going to loose the whole data since the last full backup.
according to the question it is the last differential back up which was taken at 11 pm was failed. so you should :
A. Restore the last full back up which was taken at 12 pm at midnight
B. Restore the last differential backup which was taken at 10 PM before the last backup which was fail
Alex you are wrong…. read carefully.
Last differential backup was at 3:00 AM which is failed…Immediate before 3 am ..last differential backup was at 11 PM but Full backup was at midnight which is after last good Differential Backup.
So Ans is: A
Oooh, it’s an English reading test!