Re: OK then - the outcome

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

Date: 30 Jul 2004 02:58:45 -0700

Hi All

Ok then I reinstalled SQL Server yesterday evening and decided to go
for it this morning.
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
data folder containing all the original systems databases and log
files from the SQLA install which I had copied before uninstalling
(just need to stop SQL first)

I then restarted the SQL server service and did a select @@Servername
It returned, as expected SQLA
then it was...
sp_dropserver 'SQLA'
sp_addserver 'SQLB', local
Stop the SQL service
Restart SQL Service
select @@servername now equals 'SQLB' as planned

Failed over to Node 2 sucessfully
select @@servername on node 2 equals 'SQLB' as expected
Failed back to Node 1 successfully
All databases on line and tested logins functional.

QED ;-)

If any problems do arise you can rest assured I will post them. Right
now though (for a little while at least) I'm feeling pleased with
myself - this saved me a lot of work.

Comments welcomed

Barry Lynch

Relevant Pages

  • SQL Server 2000 Virtual Server Renaming
    ... SQLA to SQLB. ... Uninstall SQL Server and reinstall. ... Am I right in thinking that I cannot restore the master from the SQLA ... Clearly I would like to do this because all the user databases are ...
    (microsoft.public.sqlserver.clustering)
  • Re: DB backup to UNC path failing
    ... it is a better to use Enterprise Mangler to change SQL Service ... > Microsoft SQL Server MVP ... >> No password change but I did notice that the account had modified. ...
    (microsoft.public.sqlserver.clustering)
  • Re: cannot generate sspi context when server in mixed authenticati
    ... Kevin Hill ... Real-world stuff I run across with SQL Server: ... after we switched it to mixed authentication mode. ... find a valid SPN for the SQL Service on the server then it should ...
    (microsoft.public.sqlserver.connect)
  • Problem configuring SQL Server 2000
    ... I had a problem before the setup intallation of SQL Server 2000 into a XP machine was successful. ... I can´t start the SQL service, it raises an error related to the sesion init. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL windows account
    ... it is better to have it as "POWER USER" built in group. ... >SQL Service account absoloutely does NOT have ... The rights required by the SQL Service ... >Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)