A database running on SQL Server 2000 always has a datafile and a logfile. The problem is that a transaction logfile is never truncated if you don't take a backup of the database. On production servers this is usually not an issue since people take backups. But in test this is sometimes forgotten and then you might run short on diskspace. You may not always have access to the SQL Server console and that's why I created the below script. With this tool you can remotely shrink a transaction logfile to free up some diskspace. All source is open and you can ask additional information about it via the forum. Comments or suggestions are offcourse welcome.

Download the source files

Discuss this article in the forum!

Default view


Database list


Files for this database


Truncate Logfile Properties