You are a database administrator for AIOTestKing.com. A database on one of the company’s SQL Server 2005 computers stores transaction information for the company’s Web-based order system. The database is configured to use the full recovery model. Your company receives very few orders between the hours of 19:00 and 04:00. Your maximum acceptable risk for data loss is one hour. Database backups must be performed as quickly as possible. You need to develop a maintenance plan to manage this risk. What should you do?
A.
Configure a Back Up Database task to do a full backup of the database every day at 19:00. Configure a second Back Up Database task to do differential backups at 09:00 and 14:00. Configure a third Back Up Database task to do transaction log backups every hour.
B.
Configure a Back Up Database task to do a full backup of the database every hour.
Configure a Check Database Integrity task to run every hour.
C.
Configure a Back Up Database task to do a full backup of the database every day at 19:00. Configure a second Back Up Database task to do differential backups at 09:00 and 14:00. Configure a Check Database Integrity task to run every hour.
D.
Configure a Back Up Database task to do a full backup at 09:00 and 14:00. Configure a second Back Up Database task to do transaction log backups every hour.
Explanation:
It is not recommended to run a full backup during business-hours in this case. Full backups should be scheduled to between 19:00 and 04:00. Checking Database Integrity every hour will not help to recover the data if the database crashes. The only alternative that would work is the Full backup at 19:00 and then transaction log backups every hour. Doing differential backups at 9 and 14 will help.