Web Wiz Support and Community Forums : We don`t need SQL server log file https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 13:06:53 +0000 Mon, 07 Jun 2004 21:52:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=10756 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[We don`t need SQL server log file : FARSHAD wrote: yes i have...]]> https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post59075.html#59075 Author: psycotik
Subject: 10756
Posted: 07 June 2004 at 9:52pm

Originally posted by FARSHAD 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).

]]> Mon, 07 Jun 2004 21:52:12 +0000 https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post59075.html#59075 <![CDATA[We don`t need SQL server log file : You canmanage it through something...]]> https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58974.html#58974 Author: dpyers
Subject: 10756
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.

]]> Sun, 06 Jun 2004 17:33:52 +0000 https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58974.html#58974 <![CDATA[We don`t need SQL server log file : yes i have a Control Panel but...]]> https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58973.html#58973 Author: FARSHAD
Subject: 10756
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

]]> Sun, 06 Jun 2004 17:33:34 +0000 https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58973.html#58973 <![CDATA[We don`t need SQL server log file : you have to ask your host to do...]]> https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58950.html#58950 Author: Semikolon
Subject: 10756
Posted: 06 June 2004 at 12:48pm

you have to ask your host to do this for you. or you might be able todo it yourself from your web control panel, if you have one]]> Sun, 06 Jun 2004 12:48:25 +0000 https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58950.html#58950 <![CDATA[We don`t need SQL server log file : Hi I want to know is there any...]]> https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58934.html#58934 Author: FARSHAD
Subject: 10756
Posted: 06 June 2004 at 5:31am

Hi

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

]]> Sun, 06 Jun 2004 05:31:07 +0000 https://forums.webwiz.net/we-dont-need-sql-server-log-file_topic10756_post58934.html#58934