Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Multiple Instances - SQLSERVER

Multiple Instances - SQLSERVER

Scheduled Pinned Locked Moved Database
3 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    clint1982
    wrote on last edited by
    #1

    Hello all How can I rename an instance of sql server not in sql. Clint

    M 1 Reply Last reply
    0
    • C clint1982

      Hello all How can I rename an instance of sql server not in sql. Clint

      M Offline
      M Offline
      Mike Dimmick
      wrote on last edited by
      #2

      I don't believe it's possible to rename a SQL Server instance. I think the only way to achieve that is to uninstall it and install a new instance with a different name. Be sure to back up all your databases before doing it so that you can restore them. Alternatively you might be able to detach and reattach the databases to the new instance (but I'd still take a backup first).

      Stability. What an interesting concept. -- Chris Maunder

      C 1 Reply Last reply
      0
      • M Mike Dimmick

        I don't believe it's possible to rename a SQL Server instance. I think the only way to achieve that is to uninstall it and install a new instance with a different name. Be sure to back up all your databases before doing it so that you can restore them. Alternatively you might be able to detach and reattach the databases to the new instance (but I'd still take a backup first).

        Stability. What an interesting concept. -- Chris Maunder

        C Offline
        C Offline
        clint1982
        wrote on last edited by
        #3

        thanks:)

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups