New Datacenter migrations

Question

Hi Team,

We have 2 Datacenters say A and B which has database mirroring configured among with its dedicated IPs for mirroring,since they are old datacenters now its planned to move new data centers called C and D.

Now the question is -

They want shutdown both the A&B at the same time and bring back C&D (as part of VM motion) but in the new datacenters the IPs will change and we have to use same IP for mirroring too.,this is the final choose they have give and no other option is accepted due to time limit.

Hence what would be the best approach.
i,e 1.we have to drop mirroring once they Brought C&D and endpoints-- then do a fresh backup and reconfigure again.

is there any way Alter endpoints can be do in a database mirroring?

Is there any other best practise in this case or plan that exists here please suggests.

SQL is 2016.

Thanks your help in advance.

Answer 1

Hi @S_NO ,

If you want to use the same IP and minimize downtime, just like you said, do a fresh backup, you can see this thread:
https://social.msdn.microsoft.com/forums/sqlserver/en-US/e614defb-f996-437b-a4bd-2f521a1ead36/db-mirroring-migration-to-a-new-sql-server-hardware

For example,
You may try for principal server create the mirror database, data sync and failover

Specify a Server Network Address (Database Mirroring)

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

We cant use the same IP , as other DC's VLAN is different.