SQL Server Management Studio 17.1 Mirroring bug

by elekgeek   Last Updated June 09, 2017 00:06 AM

I noticed there is a bug that when people asked about it, they were sent in the wrong direction. When trying to use SQL server 2016 with SSMS 17.1 to create a mirrored database, the following errors might be received:

Database is not configured for database mirroring. Database x cannot be opened. It is in the middle of a restore.

This error was a real PITA that cost me 2 weeks of searching as I am new to this DBA stuff, otherwise I would have gone the scripting path.

What is the solution?



Answers 1


The solution is to use SSMS 16.5.3!

elekgeek
elekgeek
June 08, 2017 23:22 PM

Related Questions


Distributed availability group not working with FCI

Updated November 07, 2017 12:06 PM

Sql 2016 STD SP1 Always On with DB Mirroring

Updated February 21, 2018 01:06 AM

Moving SQL to a hosted server

Updated January 03, 2018 04:06 AM

DB Migration from sql server 2014 to 2016

Updated January 10, 2018 21:06 PM