You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. The CK_DB1 database uses SQL
Server log shipping; however, log shipping will occur within the hour. You have received
instructions to make a full backup however; you need to cut the net bandwidth utilization when
maintenance takes place at night.
What should you do?
A.
You should consider setting the database to utilize the bulk-logged recovery model.
B.
You should consider adding the time during transaction log backups.
C.
You should consider disabling log shipping after the nightly maintenance.
D.
You should consider reproducing only those indexes that ask it at night.