SQL Server 2000 Virtual Server Renaming

From: BarryLynch (allspammustdie_at_yahoo.com)
Date: 07/27/04 

Date: 27 Jul 2004 08:12:19 -0700

Hi All
Client has decided they want to rename the Virtual SQL Server from
(lets say) SQLA to SQLB.

Fair enough. Uninstall SQL Server and reinstall.

Am I right in thinking that I cannot restore the master from the SQLA
incarnation to the SQLB incarnation.

Clearly I would like to do this because all the user databases are
unchanged and in the same locations and it would save me reattaching
each user database, recreating logins etc etc.

Or can I restore it and then use sp_dropserver, sp_addserver, bearing
in mind its clustered?
Thanks in advance

Barry

Relevant Pages

  • Re: OK then - the outcome
    ... In the end I didn't even restore master I just stopped sql Server ... service renamed the SQLB Data folder to xData and copied in the SQLA ... Restart SQL Service ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2000 Virtual Server Renaming
    ... In this way your client can connect to SQL Server with both SQLA or SQLB ...
    (microsoft.public.sqlserver.clustering)