Backup Transaction Log
General problem faced by most the database server is growth in transaction log file. This causes less free memory space on database server.
To recover from a situation where the transaction logs grow to an unacceptable limit, you must reduce the size of the transaction logs. To do this, you must truncate the inactive transactions [...]
Continue reading about (DBA TIPS) Maintenance Plan to avoid Transaction log file growth
This article covers the basics of Transaction Log backups and restores in SQL Server. The examples are from SQL Server 2008 however it applies to SQL Server 2005. If a database uses either the full or bulk-logged recovery model, you must back up the transaction log regularly enough to protect your data and to keep the transaction log from filling.
Continue reading about Backup and Restore Transaction Log in SQL Server
