by Tom
Microsoft is celebrating the launch of Visual Studio Express by offering it for free for the first year. This includes their Visual Web Developer 2005 Express Edition. This is a great light-weight tool for .NET 2.0 development. I’ve been using the beta version of it for the past couple of months.
Here’s the link to the download site: http://msdn.microsoft.com/vstudio/express/
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
