Re: need help setting up resources

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Resources map to physical disks, so if there are several drive letters associated with multiple partitions on a single disk, they will show up as a single resource in the Cluster Management tool. C: is local and unique to each machine so it cannot be a shared resource. SQL setup will create the correct dependencies. If you add a disk later, you will need to adjust the SQL Server to be dependent on the new disk resource. SQL Setup will also handle the creation of the SQL Agent and its dependencies.

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




"dmcmillan via SQLMonster.com" <u18500@uwe> wrote in message news:6b18263878bd3@xxxxxx
I have read that document and it is very helpful, but I do still have a
couple questions. I see that the drives on our servers don't exactly
correspond to the physical disks, so I:,J:,Q: will be added as one physical
disk type resource I guess.
The C: drive is not available as a choice when trying to add it as a physical
disk resource even though we have set it up on the servers. Any
idea why that might be and how I can get it?
What dependencies should physical disks have assigned?
Also, should the SQL Server Agent be added as a resource, if so what type and
dependencies should we use?
Thanks so much for all help!

Geoff N. Hiten wrote:
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

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
[quoted text clipped - 13 lines]
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: Help installing SQL2000 on Win2003 - MSDTC resources required?
    ... MSDTC resource but you need another physical disk and network name so I ... network name as these resources and in the same group as the SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • RE: Failed resources
    ... catastrophic result, when I just move one resource to another node, like the ... > Node A hosts normally SQL Server 2K and File System ... > Cluster resource 'Disk Z:' in Resource Group 'Cluster Group' failed. ... > Cluster resource 'Disk V:' in Resource Group 'SQL Server Group' failed. ...
    (microsoft.public.windows.server.clustering)
  • Re: Creating Database (Urgently need help)
    ... Select the SQL Server group. ... Right click in the SLQ SErver resource, ... physical disk NOT in the list cannot be used for SQL data storage. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Disk exchange on two-node MS SQL 2000 active/active cluster
    ... Bring both resource groups to the node you are logged into. ... I support the Professional Association for SQL Server ... >>> physical disk owened by the first node, ... >>> offline with cluster administrator) WHich is better? ...
    (microsoft.public.sqlserver.clustering)
  • Re: MSDTC in Cluster Group
    ... we've found out that it does not work and an instance of SQL Server ... You can put it in the SQL Server Group resource, but it won't work once you ... Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if the MSDTC has its own IP Address and Network Name? ... In my planned multiple instance sql cluster, I can see giving up a physical disk to the Quarum, but another disk to MSTDC as well. ...
    (microsoft.public.sqlserver.server)