SQLCLUSTER @@servername = NULL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » SQLCLUSTER @@servername = NULL

SQLCLUSTER @@servername = NULL

Rate Topic

Display Mode

Topic Options

Author

Message

Eliud Kataraihya-485044

Posted Wednesday, January 30, 2008 10:13 AM

Forum 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

Lester Policarpio

Posted Wednesday, January 30, 2008 8:39 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 6:45 PM
Points: 398, Visits: 2,405

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

Eliud Kataraihya-485044

Posted Thursday, January 31, 2008 3:40 AM

Forum 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 »

Permissions