You work in a&en_睦霖题库

单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup. So what action should you perform to achieve this goal？（）: A、You should recreate the indexes.; B、You should compress the log file backups; C、You should make the Dworks database use the Full recovery mode; D、You should make the Dworks database use the Simple recovery mode.

热门试题