Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 VP-Cart 8.00 Issues
 The transaction log for database XXXXX is full.		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vaheh
VP-CART New User

USA
115 Posts
Posted - June 23 2015 :  11:17:13  Show Profile  Visit vaheh's Homepage  Reply with Quote
Hi Everyone,

Have you ever seen this error "The transaction log for database is full"?

Thanks,
Vaheh

jbutt
VP-CART New User

USA
56 Posts
Posted - June 24 2015 :  11:08:37  Show Profile  Reply with Quote
Hi Vaheh,

That sounds like an error message generated by SQL Server. Are you using SQL or Access?

If you are using SQL Server ... has the error dissapeared or does it keep showing up? Usually it happens when something repeatedly triggered log entries and the server hasn''t had time to shrink or clean it up. If it still shows up, you might have something triggering the SQL Server transaction log and you need to investigate.

John
Go to Top of Page

vaheh
VP-CART New User

USA
115 Posts
Posted - June 24 2015 :  14:23:12  Show Profile  Visit vaheh's Homepage  Reply with Quote
Hi John,

SQL Server 2008.
There is no error!. Log file last night was 13GB while the DB itself is around 13MB!
SQL log file shows for every single products it is actually doing INSERT - update - DELETE many times until it crashes like aa endless loop.

Thanks for your comment.

Vaheh
Go to Top of Page

support
Administrator

4679 Posts
Posted - June 24 2015 :  21:49:54  Show Profile  Visit support's Homepage  Reply with Quote
Dear Vaheh,

We have replied to your helpdesk ticket and would also share this to the forum users :

Could you please forward these steps to your web host provider do to for you :

1. Open sql management studio

2. Right click the selected database name.

3. Choose Properties.

4. Option

5. Change Recovery model to Simple.

6. Shrink database log file.

The database log file will become 2MB after shrink process and won''t be growth again.

Thank you.
Wilson
VPCart Support
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty