Home Forums SQL Server 2005 Backups Reclaim Transaction Log Space RE: Reclaim Transaction Log Space
Adam Haines
SSC-Insane
Points: 23217
More actions
January 11, 2008 at 9:18 am
#767184
You have to shrink the log file
DBCC SHRINKFILE (N'LogFileLogicalName', 0, TRUNCATEONLY)
GO