You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 server.
Management wanted the backups to be done on a daily basis. Transaction log backups are
performed every afternoon and morning. This worked fine for six months. However, as the content
of the log file grew it resulted in a large transaction log file. The size of the transaction log file is
affecting the performance of the server. You have received instructions to take appropriate
measures when doing the backups of the transaction log files.
What is the preferred action in this scenario?
A.
Set the database to use the debug model.
B.
Decrease the size of transaction log file by using the DBCC SHRINKFILE command
C.
The number of transaction log backups should increase. Make a transaction log backup every
hour.
D.
Optimize the SQL code by reducing amount the size of the statements.
E.
The number of transaction log backups should decrease. Make a single transaction log backup
every day.
F.
.Set the database to use the simple recovery model.
Explanation:
Increasing the number of transaction log backups decreases the size of the transaction log file.