Web Wiz Forums - We don`t need SQL server log file

Print Page | Close Window

We don`t need SQL server log file

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=10756
Printed Date: 08 April 2026 at 1:14pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: We don`t need SQL server log file

Posted By: FARSHAD
Subject: We don`t need SQL server log file
Date Posted: 06 June 2004 at 5:31am

I want to know is there any way that web tell to the SQL server that don`t make SQL LOG FILE ?

or any code that i enter in the SQL setup file in the forum directory?

Thanks

Replies:

Posted By: Semikolon
Date Posted: 06 June 2004 at 12:48pm

you have to ask your host to do this for you. or you might be able to do it yourself from your web control panel, if you have one

Posted By: FARSHAD
Date Posted: 06 June 2004 at 5:33pm

yes i have a Control Panel but there is not any option for this in that

somebody told me i can use this code

ALTER DATABASE database_name SET RECOVERY SIMPLE

but i don`t know where i must use that

Please help me

Thanks

Posted By: dpyers
Date Posted: 06 June 2004 at 5:33pm

You can manage it through something like Enterprise Manager. MS SQL Server 2000 BooksOnline does a pretty good job on covering the topic. Strongly suggest you read it before playing with the DB as some of the settings don't do what you would think they do.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: psycotik
Date Posted: 07 June 2004 at 9:52pm

FARSHAD wrote:

yes i have a Control Panel but there is not any option for this in that

somebody told me i can use this code

ALTER DATABASE database_name SET RECOVERY SIMPLE

but i don`t know where i must use that

Please help me

Thanks

If you have an asp page which makes a connection to the database, simply put the following line in after the connection.

adoCon.Execute ("ALTER DATABASE database_name SET RECOVERY SIMPLE");

(assumes adoCon is the connection).