题目内容

You are the administrator of a SQL Server 2005 computer named SQL1. SQL1 contains a database that utilizes SQL Server log shipping. Log shipping occurs every 30 minutes. Each night, a full backup is made of the database, and all database indexes are rebuilt. The company’s network administrator reports that SQL1s network utilization becomes excessive after the nightly maintenance tasks are complete. You need to reduce the network bandwidth utilization for SQL1. What should you do?()

A. Configure the database to use the bulk-logged recovery model.
B. Each night, rebuild only those indexes that require it.
C. Disable log shipping before the nightly maintenance. Re-enable log shipping after nightly maintenance completes.
D. Increase the time between transaction log backups.

查看答案
更多问题

钢筋焊接及验收规程(JGJ18-2012):两根同牌号、不同直径的钢筋可进行闪光对焊、电渣压力焊或气压焊,闪光对焊时其径差不得超过(),电渣压力焊或气压焊时,其径差不得超过()

A. 3mm;7mm
B. 4mm;5mm
C. 4mm;7mm
D. 3mm;5mm

第四代计算机的主存采用半导体存储器。

A. 正确
B. 错误

当自动装置不发(),或装置()灯亮而开关未合上时,应将()装置退出运行。

在国境口岸以及停留在该场所的入境、出境交通工具上,所有非因意外伤害而死亡并死因不明的尸体,必须经卫生检疫机关查验,并签发()后,方准移运。

A. 卫生处理证明
B. 特殊物品审批单
C. 出境检疫证
D. 尸体移运许可证

答案查题题库