WHug (3/1/2016)

---

I have a SQL Server mirror with no witness with TCP. Connections are configured to use certificates. The IP address of the Principal Partner is changing; the IP of the Mirror Partner is staying the same (and using the IP's is working fine.) Safety mode is off. Due to the size of the database I want to avoid removing the mirror and then re-configuring it.

What is the process for changing the Principal Partner IP without removing and re-configuring the mirror? This is not covered in Books Online that I saw. Also, I haven't found the issue in forums.

Do I stop the end point, change it, and restart it; or do I suspend, change the IP, then resume?

It will take days to reestablish the mirror if I don’t have a workaround, or a test. Thanks in advance.

What I was thinking of trying:

From the Principal Server:

ALTER DATABASE [SomeDB] SET PARTNER SAFETY FULL;

From the Mirror:

ALTER DATABASE [SomeDB] SET PARTNER SUSPEND;

ALTER DATABASE [SomeDB] SET PARTNER = 'TCP://123.456.78.910:12345'

ALTER DATABASE [SomeDB] SET PARTNER RESUME;

From the Principal:

ALTER DATABASE [SomeDB] SET PARTNER SAFETY OFF;