Re: need help setting up resources

Try this: It is a bit long, but I think it covers pretty much everything in settint up a cluster.

http://searchsqlserver.techtarget.com/searchSQLServer/downloads/SQL_Cluster_Ezine_Final_needs_URL.pdf

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP



"dmcmillan via SQLMonster.com" <u18500@uwe> wrote in message news:6b103c55d8eb2@xxxxxx
I haven't set up a failover cluster before and hope someone can help.
It is Windows 2003, SQL Server 2005 failover cluster. We have set up 2 nodes
emrdb1 and emrdb2, cluster name is emrcluster.
Do we need to add SQL Server Agent as a resource?
How do I set up physical disks? I need C:, E:, F:, G:, I:, J:, and Q: drives
for data and transaction logs. THey are created on both nodes. Do I just add
them as new resources? I tried this and some of the disks are not available
as a disk parama\eter choice, and a few are all lumped together, I can only
select: I: (CDR_Log)J:(MSI_Logs)Q:(Q4Quorum) all together.
Where is that info coming from, can I correct it somehow?
Also what dependencies should they have?
THanks for any ideas!

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-clustering/200612/1


.

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: Quick question regarding a message from the Cluster Log
    ... - Basic disks are being used. ... cookie 4 at array index 0 into the gather cluster information task for node ... Creating a dummy Local Quorum resource. ... The resource type managed by enumerator ...
    (microsoft.public.windows.server.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... In the cluster administrator, there are 5 Groups: ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (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)
Loading