A 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. Decrease the amount of time between transaction log backups.
B. Configure the database to use the simple recovery model.
C. Configure the RECOVERY INTERVAL option to be a smaller value.
D. Run DBCC SHRINKFILE on the transaction log file.
Answer:A
A 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. Decrease the amount of time between transaction log backups. B. Configure the database to use the simple recovery model. C. Configure the RECOVERY INTERVAL option to be a smaller value. D. Run DBCC SHRINKFILE on the transaction log file.