Eprs_Admin
asked on
IP change of AG
Hi Experts,
I have running 2 SQL2014 Servers in a AG.
The WIN OS is WIN2012R2.
I have to change IPs of all servers because of a move into a new DC.
Can you help me with the steps ?
What to do first ?
I have running 2 SQL2014 Servers in a AG.
The WIN OS is WIN2012R2.
I have to change IPs of all servers because of a move into a new DC.
Can you help me with the steps ?
What to do first ?
ASKER
I have two servers. I have a windows cluster. the DBs are clustered with the AG.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So you have 2 stand-alone SQL Server instances, right?
YES.
It should be DBs are replicated through AG?
YES
YES.
It should be DBs are replicated through AG?
YES
If they are clustered instances then stop SQL Server service and change the SQL IP Address (all this tasks need to be performed in the Failover Cluster Manager snap-in). The start the SQL Server with the new IP address.
If they are stand-alones, stop the SQL Server service and change the IP locally before start again the SQL Server service.
For AG, you'll need to drop the listener from the Principal replica and recreate it giving the new IP address.