Hi Uttam et al
Uttam, well done for putting the work in. We are agreed then!!
Another clustering old wives tale finally put to rest maybe.

I am going to do this for real in about an hour so I will report back.
Many thanks

Barry Lynch

"Luca Bianchi" <rightjoinREMOVE_THIS (AT) hotmail (DOT) com> wrote

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