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 ?
Eprs_AdminSystem ArchitectAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
So you have 2 stand-alone SQL Server instances, right?
the DBs are clustered with the AG.
That's not a correct statement. It should be DBs are replicated through AG?

Anyway, this doesn't change nothing from my above comment. Resume:
  1. Stop SQL Server instances
  2. Change server IPs
  3. Reboot
  4. Start SQL Server instances (if they do not start automatically)
  5. Recreate AG listener
1
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are the SQL Server instances stand-alones or clustered?
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.
1
 
Eprs_AdminSystem ArchitectAuthor Commented:
I have two servers. I have a windows cluster. the DBs are clustered with the AG.
0
 
Eprs_AdminSystem ArchitectAuthor Commented:
So you have 2 stand-alone SQL Server instances, right?
YES.

It should be DBs are replicated through AG?
YES
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.