Here our development team consists of 3 with varying experience.

I personally tend to work with the full product range including database design, business analysis and the majority of...

Since you now have the records in the Archive table how about deleting from the main table where matching records exist in the archive table?

DELETE FROM MainTable WHERE Exists(SELECT *...