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
Technology Tips and News
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
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.