What would be the advantage with taking transaction log backup between delete batches and how does it going to reduce the log size.We have 15 Min Transaction Log Backup job...

Gail Shaw-As it in Production, database is in Full recovery model, we can change it to Simpel while deleting. As you said Second option how can I delete 500,000 rows...

But If shriking log file is not recommended on Production box,then is there any alternative solution for above situation?