Sql server mirroring: The remote copy of database is not related to the local copy of the database

2k Views Asked by At

I am trying to mirror a database following this

At step 4, after I click on Start Mirror button I got

Error Number: 1407
Severity: 16
State: 1
Line Number: 1
The remote copy of database "TEST_M" is not related to the local copy of the database.

I have restored the principal database backup to the mirror database with NORECOVERY.

Not sure what went wrong. Can anyone help?

Thanks,

1

There are 1 best solutions below

0
On

I redo the backup and restore process and it worked.