You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
The SQL Server 2008 R2 instance includes a database named ABC_DB that makes use of the
bulk-logging recovery model. You have employed a WAN connection for log shipping ABC_DB.
You have also configured ABC_DB’s indexes to be reproduced by a scheduled job that results in
the log backups growing in size.
You have been instructed to make sure that the log backups employed by log shipping is reduced
in size.
Which of the following actions should you take?
A.
You should consider making use of Database snapshots.
B.
You should consider making use of the half recovery mode on ABC_DB.
C.
You should consider making use of stored procedures.
D.
You should consider having the log file backups compressed.
Explanation: