Post reply

SQL Instance

  • January 13, 2012 at 4:37 am

    #249074

    Hi Guys......

    How to rename a SQL Server 2008 R2 named instance ?

    for eg:

    My instance name is Server name\ABC and i want to convert it into Server name\XYZ

    Reply.........thnx

  • January 13, 2012 at 4:54 am

    #1433144

    I think it's best to play safe here. That way you don't have to worry about aliases, registry entries and other things not getting changed.

    Install a new SQL Server instance with the new name, then copy the databases across, script out the logins and create them on the new instance, and so on.

    John

  • January 13, 2012 at 4:58 am

    #1433146

    So far as I know, and I may be working off of old knowledge, instances cannot be renamed. They have to be installed brand new with a new name.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • January 13, 2012 at 5:04 am

    #1433149

    Uninstall, reinstall

    Server names can be changed, instance names cannot.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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