You have a mediumsized database named Sales set to use the F

You have a medium-sized database named Sales set to use the Full recovery model. Your users insert, update, and delete data from this database frequently. You perform a full backup on this database every Saturday and differential backups Monday through Friday. One day your users start complaining they cannot update any longer. What should you do to get the database back up?

a. Set the database to use the Simple recovery model.
b. Set the database to use the Bulk-logged recovery model.
c. Back up the transaction log with NO RECOVERY.
d. Back up the transaction log.

Solution

The answer is option (D) Back up the transaction log.
To get the database backup you need to backup the transaction log with TRUNCATE only.