• 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.

    Anyway, if your tables are referenced by FKs you'll need to drop them before deleting rows and recreate them after, or, another approach would be to alter those constraints with the delete cascade option.

    Hope it helps. 😎

    Jonathan Bernardez Bernardez
    ___________________________________________________________
    DBD. MCSA SQL Server 2012