Home > IT Answers > SQL Server > SQL 2005 transaction logs
Hydrostani
20 pts.
 SQL 2005 transaction logs
sql 2005 Performance Issues, SQL Server 2005, SQL Server 2005 administration, SQL transaction logs
At what point should we truncate the transaction log

Software/Hardware used:
ASKED: April 8, 2010  1:38 AM
UPDATED: April 9, 2010  6:17 PM
RELATED QUESTIONS
Answer Wiki:
You should truncate the logs at minimum once a month depending on how much activity your sql server is performing. We do ours once a week on the weekends due to the high volume performed.
Last Wiki Answer Submitted:  April 9, 2010  6:17 pm  by  Aguacer0   8,120 pts.
All Answer Wiki Contributors:  Aguacer0   8,120 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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