You maintain a SQL Server 2008 instance that contains a database named Finance. The
Finance database currently contains 100 GB of data. On an average, 1 GB of data is
modified or inserted daily.
The recovery model of the Finance database is set to Simple. Business requirements specify
that data loss of more than two hours worth of transactions during business hours is
unacceptable.
You need to select a backup strategy that uses the least amount of disk space by adhering
to the business requirements.
What should you do?
A.
Perform a full database backup once daily.
B.
Perform a full database backup once daily. Perform a differential backup every two horns
during business hours.
C.
Perform a full database backup once daily. Perform a transaction log backup every two
hours during business hours.
D.
Perform a full database backup once every week. Perform a differential backup once
daily. Perform a transaction log backup every two hours during business hours.