多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题