Why keep a log in Massive Load if not requested

I think that user should have an option to avoid Log in massive insert operations to improve performance loading large DB especially if restart is not requested.

Thanks

Daniele

August 22nd, 2013 6:19am

Have you looked at the BULK_LOGGED recovery model?  You can use this for exactly the situation you're describing.  It minimally logs large data loads but doesn't break your log chain, therefore providing resilience.

You can read about different recovery models here:

http://msdn.microsoft.com/en-us/library/ms189275.aspx

There are also lots of other articles on the internet you should be able to easily find.

Free Windows Admin Tool Kit Click here and download it now
August 22nd, 2013 6:22am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics