Thanks for the replies. I am already the INSERTs in a batch of 5000 rows using SSIS data flow task. Should i reduce the batch size further?

As Mike pointed out...

I use the following in SSIS "Execute Process Task" and it works perfectly for me.

1. Set the Executable as "CMD.EXE"

2. Set the Argumetns under the Expression as follows:

"/C D:\\GnuPG\\gpg --encrypt...

Thanks a ton everybody.

Thanks for the explanation Steve. I agree with you. I think i was trying to say the same thing. By saying "assuming", i was trying to give a particular scenario...

Last but not the least. Run the Index defrag commands after the Delete.

If you have have read my post completely, i mentioned BACKUP LOG does need to be taken in case the trn backup frequency duration is set as 1 hour. All...

The Transaction log backup is assumed to be running every 10 or 15 minutes in a Production environment. BACKUP LOG command could be used in scenarios where the transaction log...

Firstly the deletes on Production has to be happen off-hours, this will avoid any blocking.

Secondly the deletes have to be in batches, say in a batch of 3000 to 5000...

As someone just mentioned, have a solid DR plan, have frequent transaction log backups running like every 15 minutes or even more frequent depending on the need.

Also make sure you...