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?