Compressed Database Log - 1. Empty Log EXEC ('Dump Transaction [' @ DBNAME '] with no_log') --2. Truncated transaction log: Exec ('backup log [' @ dbname '] with no_log') - -3. Shrinking database files (if not compressed, database files do not reduce EXEC ('DBCC ShrinkDatabase ([' @ dbname '])')
