Home Dashboard Directory Help
Search

Turn off logging to SQL Server by Corby Nichols


Status: 

Active


2
0
Sign in
to vote
Type: Suggestion
ID: 715753
Opened: 12/28/2011 12:35:47 PM
Access Restriction: Public
0
Workaround(s)
view

Description

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?
Details
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?

Thanks,
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 (AucklandSQL) on 12/28/2011 at 2:32 PM
Would the SIMPLE recovery not model suit your needs?
Sign in to post a workaround.