BACKUP LOG database_name WITH TRUNCATE_ONLY
USE database_name
GO
DBCC SHRINKFILE (database_name_log, 1)
GO
Use advanced navigation for a better experience.
You can quickly scroll through posts by pressing the above keyboard keys. Now press Esc to close this window.
BACKUP LOG database_name WITH TRUNCATE_ONLY
USE database_name
GO
DBCC SHRINKFILE (database_name_log, 1)
GO