InstantASP Community Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Transaction Logs Out of Control Expand / Collapse
Author
Message
Posted 24/07/2006 07:15:43
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 18/10/2006 09:12:09
Posts: 2, Visits: 14
This forum has been up and running for a while now but we have not officially launched it so it has 0 topics with 0 posts, so the database file is only 38 MB ... BUT ... the transaction logs are 82 GB (with a G).

Why on Earth would the transaction logs balloon out of control to such a drastic size without any posters?

Post #11318
Posted 24/07/2006 12:52:12


Support Supremo

Support SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport SupremoSupport Supremo

Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568, Visits: 2,507
rlasker3 (7/24/2006)
This forum has been up and running for a while now but we have not officially launched it so it has 0 topics with 0 posts, so the database file is only 38 MB ... BUT ... the transaction logs are 82 GB (with a G).

Why on Earth would the transaction logs balloon out of control to such a drastic size without any posters?

Dear rlasker3,

I believe It's happening because the SQL SERVER does not restrict growth you can tweak this and limit the growth in
the SQL SERVER Management Studio Please se the link below: 

http://support.microsoft.com/kb/873235/

You can also shrink the transaction log using the Maintenenance / SQL Maintenenance links in the InstantForum admin area, this may take a little while so you would need to extend the query time out within the web.config (InstantASP_CommandTimeout) to allow for this.

Post #11326
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ryan Healey, Mark Christianson, Bare, James Trott

Permissions Expand / Collapse

All times are GMT, Time now is 12:22pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 9 queries. Compression Disabled.
Home | Products | Purchase | Support | Company | Contact Us
Privacy Statement | © 1999-2007 InstantASP Limited. All Rights Reserved.