December 30, 2003 at 6:36 pm
My file of Transaction Log growth very much in 2 day, I don't know why happen that, I have some question and I need your help, my Transaction Log was size 6 Gb, and on two day the Transaction Log size to 13 GB, just in two day....UPPS Do you know when happen that in SQL.
Thanks for your help ?
Regards
December 30, 2003 at 7:46 pm
What kind of activity has been going on on your database?
In any case, 2 days is a pretty long time between transaction dumps. I would recommend that you dump at least once a day. I dump once an hour.
December 31, 2003 at 10:33 am
I would dump more frequently as mentioned above.
If you need to shrink it, http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
January 3, 2004 at 7:34 am
You might also want to check the type of recovery model you are using on your DB. In the full mode, the log file can grow at a very fast rate. Depending on your needs, you can set to simple recovery mode (from the database properties dialog in EM) and your log file will hardly grow at all. To help make your choices take a look at "Selecting a Recovery Model" in BOL.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply