You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance.
You have previously configured a weekly full backup, and a daily differential backup for the
database. You want to that the most recent data is available, even if the database server fails
during the work day. You also want to make sure that data loss is kept to a minimum.
Which of the following actions should you take?
A.
You should consider configuring the use of the simple recovery model.
B.
You should consider configuring the use of Database snapshots.
C.
You should consider frequent backups of the event log.
D.
You should consider configuring the use of transaction log backups that runs frequently.
Explanation:
Run a transaction log backup to safe-keep the recent transactions.