SQLCLUSTER @@servername = NULL

  • 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

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply