GilaMonster (6/22/2010)
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.
I ran the full backup on two servers that were in the "recovery mode" for 30 minutes each everytime I restarted my SQL Server and then switched to simple logging. Then I tried restarting the SQL server and they still were stuck in "recovery mode" for 30 minutes each.
I thought making the "full backup" should have restarted the "log chain" :/ please correct me if I am wrong.