@paul-2, Thanks for the reply

Yes, it is a recurrent process ocuuring every three months to move data older than 3 months to archive database on another server and delete that data from the production database.

Since the production and archive databases are to be on two diferent servers, is the table partitioning possible for this scenario?