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!

June 08, 2017 23:22 PM

Related Questions

TCP address of SQL server not working in Mirroring

Updated April 10, 2018 15:06 PM

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