MSSQL - Backup to nul

shrink_backup_to_nul.sql

use [MY_DATABASE]
go
checkpoint
go 50

-- see what's blocking the log
select name, log_reuse_wait_desc, db.*
from sys.databases db
where db.name = 'MY_DATABASE'

use master
go

-- don't do full backup
-- backup database [MY_DATABASE] to disk = 'NUL' with compression, stats = 1;

backup log [MY_DATABASE] TO DISK = 'nul' WITH STATS = 1;

use [MY_DATABASE]
go
DBCC SHRINKFILE ([MY_DATABASE_LOG], 1, truncateonly)
go