patternsqlMinor
Trouble setting up mirroring on SQL Server 2016
Viewed 0 times
sqlsettingmirroringservertrouble2016
Problem
I've setup a test SQL Server 2016 server. I've installed 2 instances, restored a backup on the primary. Then restored a backup on the secondary with
I then followed the prompts in the Mirroring Wizard off the Database Properties page and ended up getting an error:
What am I missing?
NO RECOVERY, then restored the transactional log on the secondary, also with NO RECOVERY. I then followed the prompts in the Mirroring Wizard off the Database Properties page and ended up getting an error:
Database 'Ares' cannot be open. It is in the middle of a restore. What am I missing?
Solution
For information, I had the same issue.
This is a bug in SSMS 2016, the easiest solution if to connect using an older version of SSMS (Like 2014) to run the mirroring wizard and it works like a charm.
You can also set it up using command line but it's more complicated.
This is a bug in SSMS 2016, the easiest solution if to connect using an older version of SSMS (Like 2014) to run the mirroring wizard and it works like a charm.
You can also set it up using command line but it's more complicated.
Context
StackExchange Database Administrators Q#133332, answer score: 4
Revisions (0)
No revisions yet.