Truncating SQL Server 2000 Log Files
I run several SQL Server 2000 databases that have lots of updates to them every day. Inevitably our log files grow very large. I discovered a long time ago that you could shrink them by backing them up.
All that was left was to make it back up every day so that it never grew too big to backup. Unfortunately, I let it grow to big and I was no longer able to back it up because it was now 11 gb!
Finally, after much searching, I found this tool that shrinks your log file for you using the SQL-DMO object.
Here you go: http://www.codeproject.com/database/ShrinkingSQLServerTransLo.asp
1 Comment »
RSS feed for comments on this post. TrackBack URL
For 2005, all you need is a SQL script:
(BWD is the name of the database)