You work as the database administrator at Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that runs on a Windows Server 2003 computer. Certkiller -DB01 hosts a database named CK_Projects. The Simple Recovery Model is implemented for the CK_Projects database.
You need to implement a disaster recovery plan for the CK_Projects database. Your disaster recovery plan must ensure that data can be baked up as quickly as possible and that data can be recovered as quickly as possible following a disaster. You must also ensure that no more than three hours data is at risk at any one time. You plan to perform a full backup every Saturday at 12:00 P.M. You must now plan the backup schedule that will run during the week.
What should you do?
A.
Schedule a transaction log backup every three hours, Monday through Friday.
B.
Schedule a differential backup at 12:00 P.M., Monday through Friday and schedule a transaction log backup every three hours between differential backups.
C.
Schedule a differential backup every three hours, Monday through Friday.
D.
Schedule a full backup at 12:00 P.M., Monday through Friday and schedule a differential backup every three hours between differential backups.
Explanation:
To ensure backups can be performed quickly, you need to implement differential backups every three hours. With differential backup ups, only the data that changed since the last Full backup will be saved. This means that you only need the last full backup and the last differential backup to restore the data.
A, B: The Simple Recovery Model does not transaction log the backups as it truncates the transaction logs before the transaction logs are backed up. You must change the Recovery Model to Full or Bulk-logged in order to backup the transaction logs.
D: Performing full backups every day would increase backup times.