Post reply

Server Rename

  • May 12, 2005 at 10:18 am

    #164493

    Management want to change server name, Will I be impacted if they change server name xxx to yyy. I am supporting MS-SQL 2000 or do I need to take any necesarry steps or any changes.

    Thanks

    Nita

     

     

  • May 12, 2005 at 10:24 am

    #558475

    No you won't only need to

    sp_dropserver 'old name'

    sp_addserver 'new name', 'local'

    For more:

    http://www.sqlservercentral.com/columnists/bknight/renameserver.asp

    hth

     


    * Noel

  • May 12, 2005 at 10:34 am

    #558482

    Thanks, Can I still able to open EM or QA after renaming and reboting the server and then change the name of the server

     

    Nita

  • May 12, 2005 at 10:38 am

    #558485

    You will probably have to re-register the server name if you didn't used (local) on EM but that is not a big deal (Besides That's the recommended way). QA is immune to that change.

    hth

     


    * Noel

  • May 13, 2005 at 8:18 am

    #558729

    From an administration standpoint the aboove statements are correct.  However, you also need to take in to account any applications or other interfaces to the database.  You need to check ODBC connections on client PC's, config files for applications, etc.  A change like this does not just affect you as the administrator, it has a cascading effect throughout your business.  So I would be sure to document anything that needs to connect to this server and how it accomplishes that.

  • May 13, 2005 at 9:15 am

    #558750

    You'll also want to script out all of your SQL Agent jobs and delete them before you rename the server.

    Run the scripts to restore the jobs after the rename is done.

    This will prevent the problem with not being able to modify or delete jobs after renaming the server.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;281642

    -- J.Kozloski, MCDBA, MCITP

  • May 13, 2005 at 10:37 am

    #558785

    Also...

    If you have a remote backup server, or any server that touches that server...

    If you have routines on other servers that copy files to your server...

     

    There's lots of little crooks and nannies that server names can sneak in to.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

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

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