HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Trouble setting up mirroring on SQL Server 2016

Submitted by: @import:stackexchange-dba··
0
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 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.

Context

StackExchange Database Administrators Q#133332, answer score: 4

Revisions (0)

No revisions yet.