Hello everyone,
I am running the latest version of DNN on a share hosting. Database that i am using is SQL 2005 and the problem i frequently face is as follow:
Could not allocate enough space on somewhere, Your database transaction Log for (something) is full.
As far as i dig for it i found that i have to truncate my database log files and increase its size as well.
Problem will be solved after doing above procedure, but after a day or 2 days it will get back again. It is bothering really.
I am wonder if any one could tell me firstly, why Transaction log is going to be full that fast?
Secondly, how much space is the standard and fair amount of preserve space for Transaction log? If we assign extra space then could Transaction log
I even set it to 100 MB and with auto-growth feature. but no matter. it is just taking that space as soon as possible. I don't know what is the procedure that will gets data base log full.
I'd appreciate any help on above problem.
Thank you,