Thanks. Actually, my system can handle the size, so I really don't need to truncate at this point.

What I'm really wanting is to understand why/how the transaction log can...

Thanks Paul for your reply. Do you mind telling me what this is going to do? This is a production server and I don't like taking chances 😉

Also the initial size of the log file was set to 537MB.

Wow, I can't believe that I forgot about that option...mental lapse! Thanks for pointing that out.

Great. Thank you.

Is growth history kept anywhere? Is there a query I can run that will tell me when a growth has occurred?

Great information! Thank you.

GilaMonster (7/24/2008)

---

In the ideal situation, you should disable autogrow completely and manually grow the files as and when needed.

Autogrow puts a small overhead on the system and allows the possibility...

Ok, so it sounds like you should usually restrict the growth (esp. in prod), unless there's a good reason to do otherwise.

Thanks!

Brandie Tarvin (7/24/2008)

---

Angie,

We actually have some DBs with UNRESTRICTED on them, but on the other hand, we also have several Alerts and jobs set up to monitor Hard Drive space....

So, is it good practice for any database/trans log file to restrict the growth to a little less than what your disk allocation is? (say you have a dedicated disk...

GilaMonster (7/18/2008)

---

Don't feel too easy with it. It's not something that should be done often. While you can't loose transactions, repeated shrinks and grows of the tran log increase the...

GilaMonster (7/17/2008)

---

A shrink file does not truncate. It just changes the size of the file on disk. If you're using database mirroring, transactions that have not been copies to the...

Actually, CAN I do a shrinkfile in a mirrored environment? I was told by our contractor that you should never truncate the logs since you don't know if all...

tosscrosby (7/17/2008)

---

Shrinking the log file is not so bad, if necessary. Shrinking the data

file(s) is truly not recommended. It will lead NTFS fragmentation and will definitely fragment your indexes,...