lawson2305 (5/28/2014)
ok sorry for my misunderstanding but I thought that is why you do Log backups to commit the data to the DB and clear the transaction data from the Log file to prevent excessive growth.
No.
When I get home I'll post my article on transaction logs (if someone doesn't do so first) and explain further.
So bottom line you think the db itself is ok and I just need to figure out why the heck we are getting this continued log growth.
Yup. Pretty much.
I can't think of any 'corruption' that can cause a small backup that will restore correctly.
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