This is a highly insightful post on a factor that most SEOs are missing out on.
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.
Wow! Didn’t know they would make such big changes going between betas. This page lists the important ones that you have to make on any project made in ASP.NET 2.0 Beta 1.