Web Wiz Forums - Logfile for database is full?

Print Page | Close Window

Logfile for database is full?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25149
Printed Date: 04 April 2026 at 2:13am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Logfile for database is full?

Posted By: CinemaemCena
Subject: Logfile for database is full?
Date Posted: 14 January 2008 at 4:03pm

I run the 8.04 version and since yesterday the main page is showing the following error:

Server Error in Forum Application
An error has occured while executing SQL query on database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_get_last_USR_+_count
File Name:- default.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.

Since then, many topics are not working. What can I do?!

Replies:

Posted By: WebWiz-Bruce
Date Posted: 14 January 2008 at 4:07pm

This means that the log file for the database tempdb on the server is larger than the maximum size set in SQL Server.

To fix this either set the recovery model for this database to simple or increase the storage size of this database. To do this you need to use SQL Server Studio Manager or get the SQL Server admin to do this for you.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: CinemaemCena
Date Posted: 14 January 2008 at 4:52pm

Using SQL Server Enterprise Manager I went to my forum database and it IS set to unrestricted growth and the recoery model is "simple". :S

Posted By: WebWiz-Bruce
Date Posted: 14 January 2008 at 4:54pm

Did you also check the 'tempdb' as it is this database which it says the log file is full for?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: CinemaemCena
Date Posted: 14 January 2008 at 4:58pm

Yes. Same thing. And when I tried to backup the tempdb it told me "Backup and restore operations are not allowed on database tempdb".

Posted By: WebWiz-Bruce
Date Posted: 14 January 2008 at 5:29pm

Check the size and the recovery model, then use the Shrink tool to shrink the database and files.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Jono
Date Posted: 14 January 2008 at 5:30pm

The following may be useful:

http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html - http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html

http://sqljunkies.com/WebLog/j_gaylord/archive/2005/03/08/8680.aspx - http://sqljunkies.com/WebLog/j_gaylord/archive/2005/03/08/8680.aspx

You may wish to check the drive that the tempdb is located on for free disk space (usually C: drive)

Posted By: CinemaemCena
Date Posted: 14 January 2008 at 5:44pm

I tried restarting SQL Server. Nothing. I shrank the database. Nothing.

I'm getting desperate here, guys. I have more than 700 thousand messages in the forum and 5,000+ members and they're getting really angry... :(

Posted By: WebWiz-Bruce
Date Posted: 14 January 2008 at 6:17pm

Have you tried all the things in the links Jono gave. They do look useful.

What size did it give when you run the SP to get the tempdb size it mentioned in the first link:-

USE tempdb
GO
EXEC sp_spaceused

Also as this is more of an issue with SQL Server rather than the forum software, have you tried some SQL Server forums?

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: CinemaemCena
Date Posted: 14 January 2008 at 6:55pm

More details: the problem happens only in the topics and foruns with huge number of messages.

Posted By: WebWiz-Bruce
Date Posted: 14 January 2008 at 7:28pm

If you have a look through the links Jono posted they will explain why, as the tempdb is used for many things.

You should really consult a SQL Server web site to findout how to fix the issue. It could be that you are out of memory on the server, not enough diskspace, not enough space allocated to the tempdb, or many other reasons related to the SQL Server configuration and resources.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: WebWiz-Bruce
Date Posted: 14 January 2008 at 7:31pm

I've had a look at your forum and got the error message you mention.

However the forum only has 300,000 posts so there shouldn't be such an issue. You need to check your SQL Server resources and configuration.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: CinemaemCena
Date Posted: 14 January 2008 at 7:35pm

Are you sure you looked in the right forum, borg? You said "300,000 posts", but...

"Nossos usuários postaram um total de 713.266 Mensagens em 3.238 Tópicos em 32 Fóruns."

Posted By: WebWiz-Bruce
Date Posted: 14 January 2008 at 7:46pm

It's the one at :-

cinemaemcena.com.br/forum/

If not then you have an issue with the forum on this site to, which if it is using the same SQL Server it would explain why it is also showing the same error.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: CinemaemCena
Date Posted: 14 January 2008 at 8:03pm

Yes, that's the forum. But why are you getting only 300,000 posts? That's really weird.

Posted By: michael
Date Posted: 14 January 2008 at 8:57pm

Same here - just displaying 302.788

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: Jono
Date Posted: 14 January 2008 at 9:02pm

It does sound like a space issue. How much space do you have on your SQL Server drives? I've also found this MS KB doc: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q307487 that may help - remember to backup the server before performing any of the instructions.
For you information I can access the first forum (" http://cinemaemcena.com.br/forum/forum_topics.asp?FID=16 - Críticas e Publicações do Cinema em Cena "), but not the second (" http://cinemaemcena.com.br/forum/forum_topics.asp?FID=9 - Filmes em Geral ").

Posted By: CinemaemCena
Date Posted: 16 January 2008 at 10:35pm

I've tried everything, I cleared the disk, I shrank the log, nothing has worked.

Do you think I should install the new version of the forum over the current one? (8.04)

Posted By: WebWiz-Bruce
Date Posted: 17 January 2008 at 12:18pm

Not sure if changing the version of the forum would help as this is a database issue.

Have you also ch4ecked the memory?

Check to see if you have allowed SQL Server enough memory, and check the server has enough memory installed.

Setting auto close on all your databases can help reduce the amount of memory used by SQL server by quite a large amount.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: CinemaemCena
Date Posted: 17 January 2008 at 4:01pm

Problem solved. I have two machines in our servers and the forum db was in the second machine -- something that never occurred to me, considering that machine is used only as support to the main one.

It WAS a disc space problem.

Thank you all for your help. As usual you were great and paying the licence for the forum is one of the greater investments I've ever made. :)

Posted By: WebWiz-Bruce
Date Posted: 18 January 2008 at 8:05am

Glad to here that you got the problem fixed.

Also working on increasing performance in version 10 for larger forums like your own, but does require SQL Server 2005 or higher to take advantage of the improved performance. If you are using SQL Server 2005 then it will be well worth the update as you would see a significant improvement in performance.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting