Hello all,
I'm starting work for a new client who is running the free community edition of DNN. Before our first meeting, their site developed the following error:
The transaction log for database 'NMCommunityFaithLinks' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
I searched the forums for this error, and determined I could fix it by inputting the following code into DNN's MySQL interface:
BACKUP LOG NMCommunityFaithLinks WITH TRUNCATE_ONLY
TRUNCATE TABLE eventlog
TRUNCATE TABLE sitelog
DBCC SHRINKDATABASE (NMCommunityFaithLinks);
Do I need ' around my db name?
More importantly, however, how do I access this MySQL interface?
I assume I have to log in, but when I try to access the login page via the ctl/login or /Login.aspx paths, I get the transaction log full error. I'm sure the solution to this is obvious, but this is my first time using DNN.
Once I've accessed the MySQL file, where should I put my code?
I've also learned in the forums that I can solve this problem in the future by setting the recovery model to simple.
Thank you in advance for any help you can provide.
C. Karr