SQL Server 2005 Linked servers IP address change for failover
Posted on 2012-04-05
I have a system that uses two databases, each database is on a different server.
DATBASE1 is on SERVER1 and DATABASE2 is on SERVER2.
SERVER2 is also replicated to DATABASE2 on a third server SERVER3
DATABASE1 contains a view and stored procedures that use joins of both DATABASE1 and DATABASE2 tables. On SERVER1 a Linked server is configured for SERVER2.
The quiestion is this:
In the event of a failure an the need arises to use DATABASE2 on SERVER3, would just changing the IP address of SERVER3 to that of SERVER2 work ? Obviously taking SERVER 2 off the network first.