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.
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.
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?