You administer a Microsoft SQL Server 2012 instance.
The instance contains a database that supports a retail sales application.
The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per
week.
You plan to define a backup strategy for the database.
You need to ensure that the following requirements are met:
No more than 5 minutes worth of transactions are lost.
Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose all that apply.
A.
Configure the database to use the SIMPLE recoverymodel.
B.
Create a DIFFERENTIAL database backup every 4 hours.
C.
Create a LOG backup every 5 minutes.
D.
Configure the database to use the FULL recovery model.
E.
Create a FULL database backup every 24 hours.
F.
Create a DIFFERENTIAL database backup every 24 hours.
BCDE
I attempted this exam on 29th march. I was asked to select only 3 answers not four! which are the three?
The decision boils down to… do you need a differential backup every 4 hours if the need for log backups every 5 minutes overrides that to a certain degree?
From reading about differential backups, in a restore situation you would have to restore not only the diff backup but also the full backup so more effort hence why if I was asked for 3 answers I would go with CDE.