Replacing a linked server

  • We are in the process of replacing \ upgrading a sql server. The server being replace is referenced as a linked server on other sql servers. In the past I've always shut the old server down, renamed the new server to the old server's name, change the ip address, and rebooted the new server. A simple bait and switch job.

    The network admin wants to turn the old server off, then change the dns to point to the new server without renaming anything. I don't have an experience with doing something like this.

    I'm looking for thoughts\opinions? What would you consider a best practice?

    Thanks,

    Kevin

  • Yes, works perfectly, we do this every time.

    The DNS entry for the old server is deleted and becomes a DNS alias (A record becomes a CNAME pointing to a new A record).

    If any applications have their own DNS alias for connecting to the server, they will also work without any changes. (ie. CNAME to a CNAME to A record)

  • Thanks for the info!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply