Home > IT Answers > SQL Server > Truncating the transaction log for a SQL Server 2000 database
SQL Server Ask the Experts
2,585 pts.
 Truncating the transaction log for a SQL Server 2000 database
SQL Server 2000, SQL Server database, SQL transaction logs
What is the best automated way to truncate the transaction log for a SQL Server 2000 database?

Software/Hardware used:
ASKED: September 25, 2008  7:05 PM
UPDATED: September 25, 2008  8:10 PM
RELATED QUESTIONS
Answer Wiki:
If you do not need to keep the transaction log then simply change the recovery model from FULL to SIMPLE. The transaction log will automatically truncate every few minutes as the database checkpoints and flushes the transactions from memory to disk.
Last Wiki Answer Submitted:  September 25, 2008  8:10 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _