Migration of Server

  • Admingod

    SSCertifiable

    Points: 5953

    We are looking to move the SQL server to different datacenter. Since it's a standalone instance so it can be moved using V2V or other different options. However, the IP address might change after the move? I am thinking changing from configuration manager would be suffice the IP Address Listened by the SQL Server. Do you agree?

  • Grant Fritchey

    SSC Guru

    Points: 396777

    You can't just change the IP address locally. That has to go through however you're administering IP addresses within your system. Then, yes, once that IP address changes, you'll have to change anything that refers to it by IP address. Or am I misunderstanding the question?

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Jeffrey Williams

    SSC Guru

    Points: 88712

    To add to what Grant has posted - unless you have made changes to the instance configuration's TCP/IP settings you don't need to change anything.  The default configuration isn't locked to a specific host IP address...

    Now, if you change the server name - you would need to change that in SQL Server after the migration.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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