How do I shrink a Truncate log file (full logging) on MSSQL?

0 Comments

USE DB_name
GO
DBCC SHRINKFILE(LOG_name, 1)
BACKUP LOG DB_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE(LOG_name, 1)
GO

where
DB_name = Database name
LOG_name = Database log name

--
44 views
Was this answer helpful ? Yes (2) / No (0)

Leave a Reply

reduction