|
|
|
Forum Newbie
Group: Forum Members
Last Login: 16/09/2008 00:26:08
Posts: 2,
Visits: 6
|
|
I received this message from my web host:
Our engineer has advised that you have a very large log file (details below) and you are currently overusing your server space. The file seems to relate to a forum that you implemented?
mensline_org_au_forum_Log.LDF (SQL Server database log file) is currently using 625MB on our server.
Can I delete this file and set a limit on the log file size in SQL server? Or what do I do?
|
|
|
|
|
Supreme Being
Group: Administrators
Last Login: 2 days ago @ 14:17:15
Posts: 280,
Visits: 625
|
|
There is an SQL Server Maintenance procedure which allows you to shrink a logfile and set it's maximum size, it involves taking the database offline and performing a "Shrink Logfile", then bringing the database back online, then you can apply the hard limit for the logfile, if you have any further queries or problems with this issue, please email support or open a support ticket and we'll do what we can to help.
Kindest Regards,
James Trott
Developer
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 16/09/2008 00:26:08
Posts: 2,
Visits: 6
|
|
Thanks for this suggestion. I asked the server admin to do this. I was told that he had been unable to take the database offline, because it was in use, but had found some other way to shrink the file and set the maximum size. However, now I see that the forum has crashed with the error message that:
The log file for database 'mensline_org_au_forum' is full. Back up the transaction log for the database to free up some log space.
Need help!!
|
|
|
|
|
Supreme Being
Group: Administrators
Last Login: 2 days ago @ 14:17:15
Posts: 280,
Visits: 625
|
|
Your admin has shrunk the file by reducing its maximum allowed size, from the sounds of things to a size way too small for the forum to function, suggest to him that he allows the file to grow again, rather than hard setting the log file size.
Kindest Regards,
James Trott
Developer
|
|
|
|