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


1 Answer 1


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.

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