We use database mirroring in sql server 2008 r2.
We have 1 primary server and 1 mirror server.
Our application connect to the primary instance with ip address.
If our primary server is down and we failover to the mirror server, Our application will not be able to connect.
Our plan is to put the ip address of the old primary server to the mirror (new primary).
BUT, Does changing the ip address will confuse the database mirroring setting ?
Can we do that if we think about the endpoint config ?