Re: New to clustering and need some clarification on disk resource

Tech-Archive recommends: Fix windows errors by optimizing your registry

OK,

So I have seperate cluster groups for MSCS, MSDTC, SQL, SQL Analysis.

All have their own physical disk and MSCS and MSDTC have network name and IP
online.

Is there anything else I need to set up before trying an install?

Should I just install SQL server first and then do a second install for
Analysis server?

Thanks for all you help everyone, this has been a great learning experience
for me.

"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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:85664804-8DC3-49D2-9A57-ABC9092C6390@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E29C1268-BEA8-4A24-A236-22735A813A26@xxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:722BF459-7934-49F5-AC32-B932E452EB7A@xxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: Disk exchange on two-node MS SQL 2000 active/active cluster
    ... I support the Professional Association for SQL Server ... > I have two-node cluster on Windows 2000 Adv Server sp4. ... > physical disk owened by the first node, ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to clustering and need some clarification on disk resource
    ... The clustered disk should have MDF and LDF files. ... Did you look at the SQL setup logs to see what went wrong? ... Microsoft SQL Server MVP ... running, quorum is clustered and running, cluster is healthy and i got 29 out ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server shared drives for cluster
    ... SQL Clusters use a local binary and a 'shared' data ... Windows Server 2003 and now recommend using a separate disk for MSDTC. ... but it is very easy to add another disk to the cluster ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to clustering and need some clarification on disk resource
    ... It is the actual location for the SQL log and data files. ... You need enough disk space for all your data. ... Microsoft SQL Server MVP ... coexist on the same cluster but need different cluster groups. ...
    (microsoft.public.sqlserver.clustering)
  • Re: New to clustering and need some clarification on disk resource
    ... Is the shared disk for the cluster groups that I will install SQL Server and ... disk similar to the quorum disk for MSCS? ... coexist on the same cluster but need different cluster groups. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)