SQLCLUSTER @@servername = NULL

• Eliud Kataraihya-485044

  SSC Rookie

  Points: 34

  More actions

  January 30, 2008 at 10:13 am

  #76891

  People 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 BACKUPCLUSTER

  So i used

  sp_dropserver BACKUPCLUSTER

  then

  sp_addserver PRIMARYCLUSTER

  In the process thereafter the SELECT @@servername gives NULL

  But SELECT SERVERPROPERTY('ServerName') gives PRIMARYCLUSTER

  What could be the problem and the solution to have @@servername giving PRIMARYCLUSTER

  regards,

  Eliud

• Lester Policarpio

  SSCertifiable

  Points: 7109

  More actions

  January 30, 2008 at 8:39 pm

  #773613

  Did 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 server

  "-=Still Learning=-"

  Lester Policarpio

• Eliud Kataraihya-485044

  SSC Rookie

  Points: 34

  More actions

  January 31, 2008 at 3:40 am

  #773664

  Thanks 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,

  Eliud