Hickory Nut Software Service Blog 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 ... Continue reading →