You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 sample named CKSmp1. Furthermore, CKSmp1 contains a database named CK_DB. The
CK_DB uses the bulk-logging recovery mode. You then use the WAN to log ship CK_DB.
Furthermore, CK_DB’s indexes are reproduces by a scheduled work. You then make certain that
the log shipping adds the number to the job. You need to minimize the size of the log backups
used by log shipping.
What should you do?
A.
You should consider using the Full recovery mode on CK_DB.
B.
You should consider using the half recovery mode on CK_DB.
C.
You should consider deleting the indexes and create new one.
D.
You should consider making a compress of the log file backups.