srinath.vanama (8/9/2011)
i came across similar kind of issue in my production.After database recovered i checked the log size and it is near about 170 gb. Later i shrinked the log file and my SQL server services restarts daily,till now database never gone in to inrecovery mode.
And if you shoot a dog in the head it will probably stop barking.
I wouldn't do any of those things (including daily restart).
You better read both of these before it's too late!
http://www.sqlservercentral.com/articles/Transaction+Log/72488/