Primary

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Primary

Primary

Rate Topic

Display Mode

Topic Options

Author

Message

guaro5555

Posted Tuesday, February 05, 2013 1:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2013 12:23 PM
Points: 2, Visits: 7

Hi gurus

I would like to know how can I tell wich of the two sql in my cluster is the primary one, I very new to this so take it easy on me

Thanks a bunch

Post #1416060

JeremyE

Posted Tuesday, February 05, 2013 2:26 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 2,386, Visits: 2,656

If you are trying to find out which node SQL is running on(the active node), you can use the query below.

select SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

Post #1416105

SQLAJ

Posted Wednesday, February 06, 2013 6:03 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, April 07, 2013 8:13 AM
Points: 84, Visits: 348

You did not indicate what version of SQL so I am basing this information on what I have currently running SQL 2008 R2.

There are several settings that can indicate which node is the primary. To determine that, log into the server and open Failover Cluster Manager.
Expand the tree. Look under services for an instance and right click look at properties.
Under the general tab it should indicate which node is the "preferred owner".

You can also look in the Summary of SQL Server (instance name) window.
Find the Server Name, right click and look at properties and Advanced Policies tab. This tells you which node the instance can fail over to in the event of an issue.

Looking at all this information and help screens in the Cluster Manager will help give you a better feel for the cluster as well.

______________________________
AJ Mendo | @SQLAJ

Post #1416454

guaro5555

Posted Wednesday, February 06, 2013 10:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 15, 2013 12:23 PM
Points: 2, Visits: 7

Thankssss a Bunch Gurus

I follow the Failover cluster Method and I was able to get to the tree but once I click on an instance there is no preferred owner<none>, so is it possible for this cluster not to have a primary

Thanks again gurus

Post #1416625

Bill (fluffydeadangel)

Posted Wednesday, February 06, 2013 2:19 PM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 7:34 AM
Points: 70, Visits: 218

Yes. you can have one without a primary, however I've never seen it in the wild. You can also set both up as primary. Reminder, moving nodes will cause a temporary interruption in service.

Edit: I lied, I have one in the wild >.<; . to verify I checked one of my 6 node cluster with 3 sql servers... one had no Preferred server. Soooo, that has been fixed. but yes, you can have a clustered server and no preference.

Post #1416734

johmga26ssn

Posted Thursday, February 07, 2013 2:21 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 2:20 PM
Points: 4, Visits: 7

Does anyone know how to auto-populate a contact look up or e-mail field on a custom object with the "primary" contact from Contact Roles on Opportunities? I want a user to be able to create a new record on the custom object and have it automatically pull the contact information of the "primary" contact from the Opportunity so I can build workflow to send an e-mail notification. Thanks! Hehe

bloated stomach

Post #1417353

« Prev Topic | Next Topic »

Permissions