Paralell Upgrade - Linkserver question

• Eric Peterson

  Hall of Fame

  Points: 3192

  More actions

  May 23, 2006 at 12:16 pm

  #152993

  All

  Here is an interesting one.

  I have two SQL Server 2000 production servers, on seperate machines, configured with a LinkServer connection between them.  One is PrimarySQL and the other is SecondarySQL.   The PrimarySQL and SecondarySQL are pointed to the correct machine using the IP address located in the Hosts file.  

  Now I am in the process of doing an Upgrade to my environment using a paralell SQL Server 2005 server.   On each machine, i have installed the new server, but how would I modify the hosts file to handle the now duplicate SQL servers located on each machine?

  Anyone have any ideas?

  Eric Peterson 

   

   

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  May 24, 2006 at 12:16 pm

  #639877

  I do not have a solution but a question. Why are you using a local 'hosts' file instead of DNS ?

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."