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 hourly database snapshots.
B.
Use the full-recovery model along with differential backups.
C.
Use the simple-recovery model along with differential backups.
D.
Use the full-recovery model along with transaction log backups.