Post reply

IP Migration of SQL Server 2000

  • July 22, 2009 at 7:46 pm

    #103788

    Hi Guys,

    We are going for IP Migration of our 6 window 2003 servers environment as a part of MPLS change, over this weekend. The Database is SQL Server 2000. This is just a change in the IP addresses of our severs as we are moving to new network.

    Is there any risk of SQL Server crash, leading rebuild of my database server.

    Please enlighten me with your thoughts on this.

    Thanks Yaqoob

  • July 23, 2009 at 10:13 am

    #1029113

    Hello Yaqoob,

    In my company, we changed all IP address of our enviroment. You have to check if there are aliases, hardcoded or interfaces that refers to SQL using IP, and change to hostname.

    If you have SQL cluster server, you'll need to stop the SQL Server service and change IP on Resource Group. You must be careful to perform this configuration, because the cluster service needs to change all registry keys with new IP, otherwise, the SQL Server service won't be able to come online.

    I had some problems when I migrated IP address on sql cluster enviroment, and I had to change the windows registry manually because the cluster service didn't do.

    See u,

    Tafarelo

    http:\\dicasdeumdba.wordpress.com

    Brazillian blog about database servers

  • July 24, 2009 at 3:21 am

    #1029530

    Thanks taferelo....

    My database environment is a stand alone one ( no cluster ). So, i think registry settign should not be required.

    Can u please give me a brief where you went in the registry to do the change incase i run into this risk.

    thanks

    Yaqoob

  • July 24, 2009 at 9:35 am

    #1029802

    Yaqoob,

    If you have a stand alone server, you won't need to change registry keys. When you change the server IP and start the sql server service, the SQL will come online on the new IP.

    Try to peform this operation in a development server before execute on production.

    If you need, just ask! 🙂

    Tafarelo

    http:\\dicasdeumdba.wordpress.com

    Brazilian blog about database servers

  • July 31, 2009 at 4:37 pm

    #1033204

    Tafarelo,

    Can u please give me a brief where you went in the registry to do the change incase i run into this risk.

    Manu

  • August 5, 2009 at 10:19 pm

    #1035169

    Thanks Taferelo for you help.... Cheers mate 🙂

  • August 5, 2009 at 10:31 pm

    #1035171

    Thanks Taferelo for you help.... Cheers mate 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

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