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

微软认证考试

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

You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do?()

  • A、Decrease the amount of time between transaction log backups.
  • B、Configure the database to use the simple recovery model.
  • C、Configure the RECOVERY INTERVAL option to be a smaller value.
  • D、Run DBCC SHRINKFILE on the transaction log file.
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题