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_Orders. Several data capturers enter data into the CK_Orders database everyday. The Simple Recovery Model is implemented for the CK_Orders database. A Full backup of the CK_Orders database is performed every Saturday at 2:00
A.
You are concerned that data loss may occur should Certkiller -DB01 suffer a hard disk failure. You decide to implement additional backups of the CK_Orders database on a daily basis. You want to minimize the amount of time required for the backups as well as the time required to restore the database.
What should you do?
B.
Perform differential backups of the CK_Orders database on every week day.
C.
Switch the CK_Orders database to the Full Recovery Model.
D.
Perform a Full backup of the CK_Orders database on every week day.
E.
Perform incremental backups of the CK_Orders database on every week day.
Explanation:
To minimize the amount of time required to perform the backups, you need to perform differential backups on the week days. Differential backup ups only backs up the data that has changed since the last Full backup.
Incorrect Answers:
B: The recovery model will not affect the time required for the backup or the restore.
C: Restoring data from transaction log backups will not minimize restore times.
D: SQL Server 2005 does not support incremental backups.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: database backups [SQL Server]