I have stored procedure that deletes 10 million records a night.
Everytime I run it I get Transaction Log full.... I tried running it in batches or 1 million.
How can I delete the records and ensure the log is not full so the delete completes.
I don't even care about the transaction log... they are temp tables and records.