Turn off logging to SQL Server - by Corby Nichols

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 715753 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/28/2011 12:35:47 PM
Access Restriction Public


Please create an option for turning off logging in SQL Server.

Not all databases need recovery. Our database is written to by a crawler, and the data is created every 5 to 8 minutes, and about 500,000 to 1,000,000 insert stored procedures are executed each run. In production environements this could be tens of millions of records for each run.

Our table has two tables for each table, example:
User table and a UserAlt table is used and each run the data is deleted and reinserted to keep the database in sync with the third party database(s) we are pulling data from.

If our crawler failed on a run for any reason, such as power faliure or network failure, the data would be corrected the next time the run completes successfully.

Why can this not be an option for those that want recovery versus making it manditory?
Sign in to post a comment.
Posted by Microsoft on 1/6/2012 at 1:52 PM
Posted by Microsoft on 1/3/2012 at 9:44 AM
In SIMPLE recovery mode you can already get non-logged SELECT INTO, and INSERT INTO...SELECT FROM... with a TABLOCK hint on the target table. TRUNCATE table deletes all table rows without logging already. Will these work for you?

Eric Hanson
Program Manager
SQL Server
Posted by Martin Smith on 12/29/2011 at 3:19 AM
Postgres have unlogged tables that allows this type of thing.
Posted by Dave Dustin on 12/28/2011 at 2:32 PM
Would the SIMPLE recovery not model suit your needs?