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 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?

enter image description here


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.

protected by Community Oct 27 '17 at 9:10

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.