Rename the new instance to be same the old instance

Question

Post reply

Rename the new instance to be same the old instance

am-244616

SSCarpal Tunnel

Points: 4936
More actions
December 14, 2009 at 5:56 am

#135994

Guys,
Is it possible to rename the new instance to be same of the old uninstalled instance?

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

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

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

am-244616 (12/14/2009)
Guys,
Is it possible to rename the new instance to be same of the old uninstalled instance?

Hi,

See The Discussion

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Atul DBA Hall of Fame Points: 3610 More actions · Answer 2

If you are doing a fresh installation then you may be able to use the old uninstalled name. But then old uninstalled name should be present in current installed server.

Once installation is done, named instances cannot be renamed. You need to un-install it and then reinstall. Take a backup of all user and system databases before any unistallation. You may also detach dbs, uninstall, reinstall, attach dbs.

deepzzzz SSCrazy Points: 2890 More actions · Answer 3

Try with sp_dropserver and sp_addserver stored procedures

Thanks

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

deepzzzz (12/16/2009)
Try with sp_dropserver and sp_addserver stored procedures

Did u see the posted link?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/