First off, You CANNOT REVERT this command, so be sure you want to truncate the log!
THE QUERY
Instructions: Just replace with your DB
BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( '', TRUNCATEONLY)
First off, You CANNOT REVERT this command, so be sure you want to truncate the log!
THE QUERY
Instructions: Just replace with your DB
BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKDATABASE( '', TRUNCATEONLY)