Truncating the transaction log for a SQL Server 2000 database
Home > IT Answers > SQL Server > Truncating the transaction log for a SQL Serv...
SQL Server Ask the Experts
2445 pts.
0
Q:
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?
ASKED: Sep 25 2008  7:05 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Sep 25 2008  8:10 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0