Re: New to clustering and need some clarification on disk resource
- From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
- Date: Thu, 20 Mar 2008 13:57:40 -0400
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EA9BD919-97F3-4725-AB2E-D45F7ABEDBB7@xxxxxxxxxxxxxxxx
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@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
>> >>
>>
>>
.
- Follow-Ups:
- References:
- Re: New to clustering and need some clarification on disk resources
- From: John Toner [MVP]
- Re: New to clustering and need some clarification on disk resource
- From: MJboo
- Re: New to clustering and need some clarification on disk resource
- From: Geoff N. Hiten
- Re: New to clustering and need some clarification on disk resource
- From: MJboo
- Re: New to clustering and need some clarification on disk resource
- From: Geoff N. Hiten
- Re: New to clustering and need some clarification on disk resource
- From: MJboo
- Re: New to clustering and need some clarification on disk resources
- Prev by Date: Re: New to clustering and need some clarification on disk resource
- Next by Date: Re: New to clustering and need some clarification on disk resource
- Previous by thread: Re: New to clustering and need some clarification on disk resource
- Next by thread: Re: New to clustering and need some clarification on disk resource
- Index(es):
Relevant Pages
|
