You administer a SQL Server 2008 instance that contains the AdventureWorks database.
The Adventure Works database uses the bulk-logged recovery mode. You log ship the
AdventureWorks database across a WAN link. There is a scheduled job that rebuilds the
indexes of the AdventureWorks database. You discover that the job increases the size of the
log backups for log shipping. You need to minimize the size of the log backups used by log
shipping. What should you do?
A.
Compress the log file backups.
B.
Change the job to drop the indexes, and then recreate the indexes.
C.
Alter the AdventureWorks database to use the Full recovery mode.
D.
Alter the AdventureWorks database to use the Simple recovery mode.