Replace database Mirroring Principle Server

by craig king   Last Updated May 25, 2017 16:06 PM

I have been asked to look at the steps required to replace a Windows 2012 R2 Server that is used as the Principle Mirroring server due to it being "sized" wrongly at the time of design I'm just looking to see what steps to use that would be the best way to achieve this. I was thinking the following but would appreciate if there may be an easier less disruptive way of doing it? Thanks

  1. Manual Failover the databases so the Mirror is now the Principle and the Principle is now the Mirror
  2. Remove Database Mirroring
  3. Remove the "old" windows server that originally was the Principle
  4. Bring online the "new" windows server and setup SQL Server
  5. Re-establish mirroring between the 2 servers through setting up mirroring steps
  6. Manual Failover the databases so the new server is acting as the principle.


Related Questions




Mirroing failover command taking too much time?

Updated August 21, 2017 07:06 AM

Endpoint modification in SQL Server mirroring

Updated February 22, 2016 06:02 AM

Strange Database Mirroring Problem

Updated April 07, 2016 08:02 AM