Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

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.
0
alcindor
Asked:
alcindor
1 Solution
 
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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now