sql box moved

  • what happens if the physical location of a box(which had sql server 2000 on it) is chaned.

    what happens to the replication and distributed queries.

    Thanks.

  • I would think that as long as your host name remains the same and you stay within the same domain, you should be OK.  DNS will resolve the hostname to the new IP adderess.  As long as the moved server is on a network segment that can be seen by the replication server, you should be good.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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