Archive for August, 2007

Easy way to kill MS SQL server transaction logs

19 August 2007

I manage many SQL 2000 databases. And many times while performing maintenance I have run into the ‘transaction log full’ error.
like this: Error: 9002, Severity: 17, State: 2 The log file for database ‘%.*ls’ is full.
So like many people I resort to using the commands [...]