Home Forums SQL Server 2005 Backups Reclaim Transaction Log Space RE: Reclaim Transaction Log Space
Adam Haines
SSC-Insane
Points: 23217
More actions
January 14, 2008 at 7:20 am
#767663
Well one thing you should watch out for is the use of the truncate command, as this will break your backup chain.
There is really no penalty for shrinking the log becuause you are just returning the log to the original file size.