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
Roger AlcindorAsked:
Who is Participating?
 
unsatiatedCommented:
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
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.