SQL Server Error - Log

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
lostcontrol Members Profile Find Members Posts Groupie Joined: 13 January 2006 Status: Offline Points: 58	Post Options Post Reply Quote lostcontrol Report Post Thanks(0) Quote Reply Topic: SQL Server Error - Log 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

lostcontrol Members Profile Find Members Posts Groupie Joined: 13 January 2006 Status: Offline Points: 58	Post Options Post Reply Quote lostcontrol Report Post Thanks(0) Quote Reply Posted: 18 April 2006 at 11:49am
	Thx for your help Borg! Edited by lostcontrol - 18 April 2006 at 11:50am

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.