You are the systems administrator for your company. You install Windows Essential Business Server 2008 Premium Edition on the network. The database server runs SQL Server 2008 and is named SQL1. SQL1 contains a database named Corpdb that is configured to use the Simple Recovery Model.
You configure backups for the Corpdb database as shown follows:
* A full backup occurs at 1:00 A.M. and 1:00 P.M. daily
* A differential backup occurs every two hours beginning at midnight
A user in the Corpdb database drops a table at 11:30 A.M. You discover that the last update on the table was performed two days ago.
Which restoration method will you use to recover the dropped table to the most recent point in time?
A.
Restore the database from the most recent full backup.
B.
Restore the database from the most recent full backup, and apply all of the differential backups.
C.
Restore the database from the most recent full backup, and apply the latest differential backup since the last full database backup.
D.
Recover the database from the most recent full backup and the most recent differential backup, and then apply the most recent transaction log backup.
Explanation:
You should restore the database from the most recent full backup and apply the latest differential backup since the last full database backup. To recover a database from a series of full and differential database backups, you should restore the database from the most recent full database backup and then apply the latest differential backup. In this scenario, the database is configured to use the simple recovery model. Therefore, you cannot use the transaction logs for recovery. In a database that uses the simple recovery model, backups of the transaction logs are not maintained.You should not restore the database from the most recent full backup because it will only restore the database to the point when the full database backup was taken. To restore the database to the most recent point in time, you should also apply the latest differential backup performed after the most recent full database backup.
You should not restore the database from the most recent full backup and apply all of the differential backups. After restoring the database from the most recent full database backup, you are only required to restore the latest differential backup since the most recent full database backup. You are not required to restore all of the differential database backups, since the most recent one will include all data from the previous differential backups.
You should not recover the database from the most recent full backup, followed by the most recent differential backup, and finally by the most recent transaction log backup. In this scenario, the database is using the simple recovery model, and a backup of transaction logs is not maintained in the simple recovery model.