You administer a SQL Server 2008 database solution. All data modifications are performed
through stored procedures that use only the INSERT, UPDATE, or DELETE statements.
You are designing a backup strategy. You need to ensure that the following business
requirements are met: The backup strategy supports point-in-time recovery for failure at
any time of day. The transaction log uses the least amount of disk space. What should
you do?
A.
Use the full-recovery model along with differential backups.
B.
Use the simple-recovery model along with differential backups.
C.
Use hourly database snapshots.
D.
Use the full-recovery model along with transaction log backups.