You work as a database administrator at ABC.com. ABC.com is making us of a SQL Server 2008
R2 instance, which includes a database that hosts transaction data for ABC.com’s Web-based
order system.
The full recovery model is used on the database. The Web-based order system is utilized 24/7.
However, there are not many orders placed between 11 PM and 5 AM.
You have been instructed to devise a backup strategy that allows for the backup process to
complete in the least amount of time, while keeping the acceptable data loss to 60 minutes.
You have configured a full backup to run at 11 PM on a daily basis.
Which of the following actions should you take NEXT?
A.
You should consider configuring an incremental backup to execute every 60 minutes.
B.
You should consider configuring a snapshot backup to execute every 60 minutes.
C.
You should consider configuring a differential backup to execute every 60 minutes.
D.
You should consider configuring a transaction log backup to execute every 60 minutes.
Explanation: