Mirror instance not up then Principal instance was down

43 views Asked by At

I set up a Database Mirroring follow to this artic:

Step-by-step guide to configure Database Mirroring between SQL Server Instances in a Workgroup

I have 3 PCs were join Domain. Window server 2012 R2 Standard + MS SQL 2008R2 Enterprise Edition (61 bit)

  • one DC as a Witness. 10.1.1.10/24
  • one as Principal 10.1.1.12/24
  • one as Mirror 10.1.1.11/24

My build was OK but when I down the Principal instance, the Mirror not UP it was (Mirror,Synchronized/ Restoring..). When I start up the Pricipal again, the field Witness on Mirror is empty.

I cannot find what's the problem and the solution? This is the first time I do it.

1

There are 1 answers

0
Steven On

I just made it work.

I remove all and create again with set port 5022 for all instances instead of 5023 and 5024 as a article.

You must set diffirent port when all instances only stored in a SERVER