yessen (6/22/2010)
Is there a good way to maintain .ldf size at certain size? I tried to set the MAXSIZE = 10gb but when it reached that size my database could no longer make transactions and I had to get rid of that limit by setting it back to -1. All I am trying to do to set it to certain size and still continue writing the most recent transactions.
Please read through the article I referenced.
To keep the log from growing, you need regular log backups. Don't limit the size of the ldf, you'll cause problems if you underestimate how big it needs to be.
When I do "full database backup or differential database backup", does that shrinks the .ldf size?
No.
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