How to BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008, R2, 2012

BACKUP LOG WITH TRUNCATE_ONLY is a dangerous command: it empties out the contents of your SQL Server’s transaction log without really backing it up.  Database administrators sometimes run this command right before shrinking their log file with a DBCC SHRINKFILE command, thereby freeing up drive space. Why ‘truncate_only’ is not a recognized backup option. When…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}