srinath.vanama (8/9/2011)
if Log size is huge simply shrink log files. and then restart services.
Nope. Bad advice and may in fact cause the problem you say it will prevent if the log regrows with inappropriate growth increments. See http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx and http://www.sqlskills.com/BLOGS/KIMBERLY/post/8-Steps-to-better-Transaction-Log-throughput.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability