Re: Cluster Groups & Quorum

Check out www.clusterhelp.com. They have a great course on clustering - and
they cluster just about anything.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F606D39-1A38-4A92-AB1D-A5C1C7470CD0@xxxxxxxxxxxxxxxx
Yes, Q is the SAN Drive. I have been reading some clusting books and I have
seen alot of picutes of Cluster Administrator with a Local Quorum. I was
worried I set my Quorum wrong. Thanks for the info.

"Geoff N. Hiten" wrote:

Navisphere agent is the EMC client application.

Until the cluster is established, all SAN disks appear as locally attached
storage. If Q: is a SAN-based disk, then you should be OK.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OVDPhtuCIHA.4956@xxxxxxxxxxxxxxxxxxxxxxx
Typically, you don't go with a local quorum, unless you're in a
single-node
cluster. Why aren't you using a shared disk resource?

I'm unfamiliar with:

Generic Service (Navisphere_Agent)

I'm wondering why this is in the cluster group.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Paul" <Paul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:982E6461-661C-448F-BFA0-49C433560CBE@xxxxxxxxxxxxxxxx
I have a 2 node SQL 2005 cluster. I have a few questions about the
Quorum
resources. When I setup the cluster I pointed the vitural server quorum
resource to a local disk. (Q:\MSCS). I feel like I did not set this up
correctly. The 4 Resources types I have in the First Resourece group
is.
(
See Below). Do I need to create a Local Quorum resource in my Cluster
Group
and change my setting on the vitural server Properties (Quorum Tab) to
point
to the Local Quorum resource? Better yet I have found a few guides on
TechNet and other places. Does anyone have a best practice on setting
up
Cluster Administrator. I have also 2 other Groups one for MSDTC and the
Other has SQL server 2005 see below.

Cluster Group
IP Address
Network Name
Physical DIsk
Generic Service (Navisphere_Agent)

MSDTC Group
MSDTC IP Address
MSDTC Network Name
MSDTC Physical Disk
MSDTC Resource (Distributed Transaction Coordinator)

SQL Server 2005 Group
Analysis Services
Disk F: (Physical Disk)
Disk G:
SQL IP Address
SQL Network Name
SQL Server
SQL Server Agent
SQL Server Fulltext




.

Relevant Pages

  • Re: Fulltext failure on a 2 node cluster
    ... No cluster resource for that cluster has shown as failed. ... There are NO error messages in SQL Server or the event log. ... Server full-text search resource online: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Passive node starting the SQL Server services - services set t
    ... this is an HP BL40p blade cluster. ... Microsoft SQL Server MVP ... Preferred owners list IS sorted by most preferred owner first. ... lost the IP ADDRESS resource long enough to start a failover or restart ...
    (microsoft.public.sqlserver.clustering)
  • Re: Passive node starting the SQL Server services - services set t
    ... The point of a cluster is to have redundant hardware as a hot spare. ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ... the preferred owners for the resource group and possible ...
    (microsoft.public.sqlserver.clustering)
  • Re: Set up FTDATA on Failover Clustering
    ... Creating Databases or Changing Disk File Locations on a Shared ... Cluster Drive on Which SQL Server 2000 was not Originally Installed" ... If you have a secondary shared cluster disk AND if the SQL Server resource ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Starting SQL Server Resource Group failed
    ... server if that was the case then your cluster will always fail as this group ... The installation of the Virtual SQL Server 2005 went well, ... "All resources did not come online and therefore you will need to manually ... If I want to bring the Resource Group online, the SQL Server Starts, but a ...
    (microsoft.public.sqlserver.clustering)