Jeff Moden (10/20/2013)
jonysuise (10/20/2013)
Hi simonholzman 14059, and welcome to the forum 😀To delete a large number of rows switch the recovery model of your database (in your development environment) to bulk-log, run your script and switch back to full recovery. This should do with the log issues.
Careful now... while that may (as in might) deal with what you perceive to be "log issues", switching to "Bulk Logged" will possibly create other log issues insofar as the ability to do "point in time recovery" should you need to ever do a restore.
In this particular case - where the data is a copy from production and only part of the data is needed - I don't believe point in time restore is necessary. Personally I would even switch to simply recovery model (on the training databases that is, of course).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP