Solved

SQL Server 2005 Linked servers IP address change for failover

Posted on 2012-04-05
1
544 Views
Last Modified: 2012-06-27
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
Comment
Question by:alcindor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
unsatiated earned 500 total points
ID: 37813824
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

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question