New to clustering and need some clarification on disk resources

#**141**

I will make double sure that is how it is set up. I thought for sure I had
it set up that way.

Thanks again for all your help.

"Geoff N. Hiten" wrote:

Quote:

One "Gotcha" that a lot of people fall into is you cannot be logged into the
second node, only the primary, during a cluster install.

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

"MJboo" <MJboo (AT) discussions (DOT) microsoft.com> wrote in message
news:88C564C2-B246-4400-B393-1D3B367D80EF (AT) microsoft (DOT) com...
It failed to start the SQL browsing agent. But when I checked both nodes
it
was running so, I didn't get why it was a problem. But the setup failed
and
rolled back from there. I did a regular SQL install just to see what
would
happen and it worked like a charm, so I am guessing that it is something
that
is just a little off in my clustered env.

"Geoff N. Hiten" wrote:

Your local disk should have binaries. The clustered disk should have MDF
and LDF files.

Did you look at the SQL setup logs to see what went wrong?

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

"MJboo" <MJboo (AT) discussions (DOT) microsoft.com> wrote in message
news:EA9BD919-97F3-4725-AB2E-D45F7ABEDBB7 (AT) microsoft (DOT) com...
OK,

Thanks for your help Geoff,

I went ahead and tried the install, I have the MSDTC clustered and
running, quorum is clustered and running, cluster is healthy and i got
29
out
of 29 on the compatiblility checker or whatever that first stage of the
install is.

I have a different users that is a local admin on all nodes setup for
services, I have 3 domain groups setup for sqlserver, sqlagent, and
sqltext,
and I have a clustered disk setup and visible from both nodes for the
SQL
cluster group.

I went through the install and it failed. What am I missing?

I see that some data is installed to the SQL sluster group drive and
some
to
the local E:\ data drive. Is that supposed to work that way.

"Geoff N. Hiten" wrote:

It is the actual location for the SQL log and data files. That is the
resource that has to move between hosts during a failover event. You
need
enough disk space for all your data. Note that you can and should
use
multiple LUNs, preferably backed by different physical disks, for data
and
logs.

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

"MJboo" <MJboo (AT) discussions (DOT) microsoft.com> wrote in message
news:85664804-8DC3-49D2-9A57-ABC9092C6390 (AT) microsoft (DOT) com...
Thanks for that clarification, I just about ready to roll this out.

But in reading more posts, I have one more question.

Is the shared disk for the cluster groups that I will install SQL
Server
and
Analysis services on where the actual data is going, or is that just
a
small
disk similar to the quorum disk for MSCS?

I am asking becuase I only have 3 1GB shared drive presented to each
server
for needed physical disk requirement to create a new group. I want
to
make
sure I share out 150GB disks to each if necessary for the actual
application
instance if necessary.

"Geoff N. Hiten" wrote:

Yes. SQL Server Database Services and SQL Server Analysis services
can
coexist on the same cluster but need different cluster groups.

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

"MJboo" <MJboo (AT) discussions (DOT) microsoft.com> wrote in message
news:E29C1268-BEA8-4A24-A236-22735A813A26 (AT) microsoft (DOT) com...
Thanks for your help Russ!

I used the documentation and shared disks amonst 2 servers from
SAN
for
3
different Cluster groups, one for the root MSCS, one for SQL
Server,
and
One
for analysis services.

Can both Analysis and SQL server be on the same server cluster as
long
as
they have their own separate Cluster Group and their own physical
disk?

"Russ Kaufmann [MVP]" wrote:

"MJboo" <MJboo (AT) discussions (DOT) microsoft.com> wrote in message
news:722BF459-7934-49F5-AC32-B932E452EB7A (AT) microsoft (DOT) com...
Is this article relevant to 2k3 EE SP2? I see it references
no
SP
and
SP1.

Yes, it applies to 2003 EE, SP2 as well.

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp class is:
May 12-15 in New York

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

New to clustering and need some clarification on disk resources

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: New to clustering and need some clarification on disk resource - 03-20-2008 , 02:25 PM