Skip to main content
Planview Customer Success Center

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.