DBCC SHRINKFILE(,) DBCC SHRINKFILE('PS_10150_log',8000) ------- USE DatabaseName GO DBCC SHRINKFILE(, 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE(, 1) GO