Unanswered: Temporarily disable logging during large inserts?
I have an application that dumps massive amounts of data into a database during the installation. My log file always ends up being 30-40GB+ at the end of the install. Can I turn off logging while I do the install and enable it after? What are my options.
My application reads data on the fly from an external source and inserts it into a database. Basically we take a massive amount of data from a legacy system, parse it and insert it into a database. A bulk copy is not possible.
Yes, you can turn off logging during the install. You'll want to turn logging on again following process completion, and then run an immediate full backup to ensure recovery. You also risk losing any other transactional data entered into the system while the process runs, so you should consider restricting access during that time as well.
If it's not practically useful, then it's practically useless.