Clearing a transaction log

To clear the transaction log of a SQL2000 database:

BACKUP LOG [databasename] WITH NO_LOG

This will break the log, and reduce the size of the log file.  This is a dangerous operation, and should not be part of a maintenance routine.  SQL Server has better mechanisms to manage log file size in almost every case.

For more detail, see: