You are a database administrator for your company. 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 hour.Configure a Check Database Integrity task to run every hour.
- B、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.
- 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.
正确答案:B
答案解析:有

微信扫一扫手机做题