CHECKPOINT EXEC sp_helpdb 'MyDatabase' DBCC SHRINKFILE(MyDatabase_log,10) BACKUP LOG MyDatabase WITH TRUNCATE_ONLY EXEC sp_helpdb 'MyDatabase'