URGENT. SQL Transaction Log

T

tomfloate

Perch
Hi,

The transaction log on my database

hiddene_ecomm is getting really big.
I have tried to change the ratio and disk space to give it more room but to no avail ... its says 'An error occured, tech support contacted'. Can you either give the transaction log more space or make the ratio higher so transaction log can take up more space than database?

if u can free it, i tried to increase the size of my db but it didn't work.

Can I also that the recovery mode be set to simple

i raised a ticket number but have had no response and this is fairly urgent as hspher is not responding.

Ticket ... GKU-33666-847
 
tom, on SQL 2005 this is a bit of a known issue, once the transactin log goes full it won't let you edit the size, ratio or anything, annoying but true it won't even let us from admin level in Hsphere do it, until the transaction log is cleared.
 
I'm getting a similar issue - not as urgent since I'm just beginning to build the site. All the forums posts I see recommend clearing the transaction log, but can someone tell me where this is, and how one can clear it?
I use Aqua Data Studio.

Thanks
 
Submit a ticket for that, there are a few things that can be done and developing or high active DBs are the most likely to have this as an error.
 
Stephen,
Thanks, opened a ticket and they fixed it (I think).

I'm new to SQl (converting up from Access), so I'm curious what others recommend as a good db size, and especially the recommended ratio of Database/Transaction Log sizes?

My new settings are:
Database/Transaction Log file quota ratio 30 %
Used database file 1.75 MB out of 30.00 MB
Used transaction log file 0.75 MB out of 70.00 MB
Used total 2.5 MB out of 100 MB

This is a small e-commerce site. In it's old Access system the databases were pretty large - about 30Megs sometimes for the order dbs before I periodically cleaned them out. My understanding is that SQL is better at re-using space and compressing, but is a total of 100Mb a reasonable size, or should I increase it even more?

Thanks
 
You must log in or register to reply here.
Back
Top