InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 10:30:19 GMT20http://www.sqlservercentral.com/Forums/Topic449532-5-1.aspxThanks Lester,However after using the sp_addserver i did use the cluster administrator to stake offline the sql server and bring IT online again.Same as restarting the MSSQLSERVER service.That normally does it for the nonclustered servers.I suppose that should have worked!Is that correct?I am yyet to restart the servers though!regads,EliudThu, 31 Jan 2008 03:40:53 GMTEliud Kataraihya-485044http://www.sqlservercentral.com/Forums/Topic449532-5-1.aspxDid you restart the server after you used sp_dropserver and sp_addserver?? because i think the changes will take effect after you've restart the serverWed, 30 Jan 2008 20:39:40 GMTLester Policarpiohttp://www.sqlservercentral.com/Forums/Topic449532-5-1.aspxPeople my master on the cluster of 2 nodes has being restored from the backup cluster with two nodes as welll.In the process after restoring the SELECT @@servername gives BACKUPCLUSTERSo i used sp_dropserver BACKUPCLUSTERthen sp_addserver PRIMARYCLUSTERIn the process thereafter the SELECT @@servername gives NULLBut SELECT SERVERPROPERTY('ServerName') gives PRIMARYCLUSTERWhat could be the problem and the solution to have @@servername giving PRIMARYCLUSTERregards,EliudWed, 30 Jan 2008 10:13:06 GMTEliud Kataraihya-485044