SQL Server 2005 Linked servers IP address change for failover

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.
LVL 2
alcindorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
unsatiatedConnect With a Mentor Commented:
As long as you are using windows auth for the linked server and it was added by IP instead of by name.  If the link was created by utilizing the name server2, you will require updating DNS perhaps as well.
0
All Courses

From novice to tech pro — start learning today.