SQL Server Error - Log
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=19389
Printed Date: 12 April 2026 at 9:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server Error - Log
Posted By: lostcontrol
Subject: SQL Server Error - Log
Date Posted: 18 April 2006 at 11:30am
While moving my old forum to WWF, I got the following error message:
Microsoft OLE DB Provider for SQL Server
The log file for database 'dbname' is full. Back up the transaction log for the database to free up some log space.
As I am new in using SQL Server I have no clue on what needs to be done to fix this... any help much appreciated!
Thx
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 18 April 2006 at 11:46am
The SQL Server database's recovery model needs to be changed to 'simple'
At the moment the SQL Log file has grown larger than is permitted by the database admin, by setting it to simple should clearup this problem and give your forum better 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
|
Posted By: lostcontrol
Date Posted: 18 April 2006 at 11:49am
Posted By: WebWiz-Bruce
Date Posted: 18 April 2006 at 11:53am
I've not come across EMS SQL Manager, but I doubt this tool can do this.
You need to download SQL Sever Studio Manager, MS do a free Express version, this tool allows you to make changes to your SQL Server remotely.
However, you still may not have permissions to do this and you may need to contact the SQL Server admin and get him/her to make the changes.
-------------
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
|
|