You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do?
A.
Configure the RECOVERY INTERVAL option to be a smaller value.
B.
Run DBCC SHRINKFILE on the transaction log file.
C.
Configure the database to use the simple recovery model.
D.
Decrease the amount of time between transaction log backups.
Explanation:
The transaction log file shrinks every time it is backed up as it contains all transactions since last backup. In order to minimize the transaction log filesize and mimnimize the data loss in the event of failure you should backup the transaction log more often.