A solution was found but not the one I was looking for. The application is able to point to a different server for the Archive data. This means...

Thankyou for asking. First, the application software does not archive to a separate database. The application does archive to a separate set of tables which I would put...