Backup weekly current production db to Historical db server
You can look into replication as well (not sure if it works on AWS though)

[Prod SQL] --> [Archive SQL] constantly

periodically delete on Prod: anything > 90 days
periodically delete on Archive: anything > 365 days maybe?

If not replication, does "linked server" work on AWS?

Not sure what you mean by "register"