Post reply

Change server name but with Instances

  • January 30, 2004 at 2:28 pm

    #82150

    Hi all,

    Just to take the last post on this a little further. I need to change the name of my new Server 2003 machine once I have it fully tested.

    Does this work for the instances as well? I have the default plus one more instance.

    sp_dropserver <old_Name>

    go

    sp_addserver <new_name>

    go

    How do I qualify the instance? Is it ServerName.InstanceName ?

    Any help would appreciated. I haven't done this before so I'm not sure what all I'm getting myself into. I did get the note on the job definitions to change the originating server or recreate the jobs after the rename.

    Anything else I can anticipate breaking?

    Thanks

    K

  • January 30, 2004 at 4:22 pm

    #492416

    If you check what's in sysservers now, you should see

       server/instance

    in a row. Don't forget to add the ", local" to the addserver call.

  • January 30, 2004 at 5:03 pm

    #492423

    Should be server\instance

  • January 31, 2004 at 3:59 pm

    #492441

    Whoops

     

  • February 2, 2004 at 10:30 am

    #492505

    Thanks so much

    K

Viewing 5 posts - 1 through 4 (of 4 total)

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