Google Groups : Remedy ARS: "One method I have used many times without any problems is to Detach the
database, delete or rename the transaction log, and then Attach the
database. A new empty transaction log will be created.

SQL Server 2000. "