Web Wiz Forums - Not enough storage is available to complete this o

Print Page | Close Window

Not enough storage is available to complete this o

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=28228
Printed Date: 02 April 2026 at 4:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Not enough storage is available to complete this o

Posted By: stratton65
Subject: Not enough storage is available to complete this o
Date Posted: 12 January 2010 at 2:44am

Provider error '8007000e'

Not enough storage is available to complete this operation.

/forum/forum_topics.asp, line 562

Forum has been installed and running problem free for about three months. Under 50,000 posts, about 2,400 members. The largest forum section starting returning the above error just in the last few days. Running on SQL 2000 db.

http://www.allischalmers.com/new/forum

Any ideas?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 12 January 2010 at 10:41am

It looks like the SQL Server has run out of resources. With the old SQL Server 2000 it can be hard toi tell, it could be memory or it could be diskspace. You would need to check your SQL Server to see.

However, especially with a busy forum you should look at using SQL Server 2005 or 2008 instead as these databases support improved server side paging which will mean your forum will run 1,00's of times faster, use less resources and easily cope with millions of posts.

If you have to carry on using SQL Server 2000 then you would need to make changes to your forum to reduce the server load such as changing the default of 'Any Date' for topics shown in your busy forums to something much lower like one or two weeks. This can be set by editing your forum details in the admin area.

If you are using SQL Server 2005 or 2008 you do not need to do this as the server side paging means that you do not have this issue.

-------------
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: stratton65
Date Posted: 12 January 2010 at 4:28pm

Would the free Express Version of SQL 2008 be better than Standard Edition 2000?

Posted By: stratton65
Date Posted: 12 January 2010 at 11:01pm

Where can I find documentation for migrating to another DB?

Posted By: WebWiz-Bruce
Date Posted: 13 January 2010 at 9:53am

Yes using the free Express version of SQL Server 2008 would be better than using SQL Server 2000.

The Free Express Edition is more than powerful enough for running websites and forums and have even see SQL Server Express 2008 running more than 250 databases for websites, some with fairly large forums with 250,000 + posts without any problems.

To move your SQL Server 2000 database to SQL Server 2008 Express just create a backup of your database (.bak file) and then restore the database to SQL Server 2008. It's as simple as that.

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