Archiving job error on Changepoint and Archive databases that have mirroring setup
Symptoms
Error message:
The operation cannot be performed on database "Changepoint" because it is involved in a database mirroring session.
Reason
In the Archiving job there are "ALTER Database" statements, which are not allowed on a mirrored database.
Resolution
The Archiving job is a maintenance job that does not run daily. The Mirroring should be disabled while the Archiving job runs and then re-enabled after the Archiving job is completed.