SQL 2005 Shrink Log Files Without Management Studio

Date July 5, 2016 Author By kadmin Category SQL Server 2005

Paste this into Query Analyzer

USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

source