We have several databases. All of them are mirrored. Until now, we never had issues with this.
One database had some problems, and now when we try to enable mirror again, it just stops. Message in the SQL Log is
Database mirroring has been terminated for database 'databasename'.
What we do:
- Create full backup of the primary database - Create backup of the transaction log, in the same backup file - Restore that backup on the secondary location, with the norecovery option - Set partner on mirror, then primary.
The primary gets status 'Principal, synchronizing' for a moment, but then it just stops and terminates the mirroring. Placing the mirror back in restoring state and the principal just as a database with no mirror.
What can we do to investigate what is going wrong here? I think the endpoints are fine, because the other databases have no problem at all.
Thanks for any advices.