Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLCLUSTER @@servername = NULL Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 10:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 9:58 AM
Points: 2, Visits: 8
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
Post #449532
Posted Wednesday, January 30, 2008 8:39 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 06, 2014 2:38 AM
Points: 398, Visits: 2,423
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

Post #449787
Posted Thursday, January 31, 2008 3:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 9:58 AM
Points: 2, Visits: 8
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
Post #449850
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse