sql server clustering: need help setting up resources -- sql server clustering

Re: need help setting up resources

Geoff N. Hiten
12/20/2006 7:57:25 PM

sql server clustering:

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

[quoted text, click to view]

need help setting up resources

dmcmillan via SQLMonster.com
12/20/2006 10:52:44 PM

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

Re: need help setting up resources

dmcmillan via SQLMonster.com
12/21/2006 12:00:00 AM

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!

[quoted text, click to view]

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

Re: need help setting up resources

Geoff N. Hiten
12/24/2006 4:11:26 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server clustering group.