Re: Cluster configuration with SQL Server 2000

Can you explain more deeply what you mean :
- I can't create a new group, because I have only one physical disk. True?
- So all my partitions will reside in the cluster Group. Is it possible to
have such a group??
- Is it possible to install SQL Server 2000 using the cluster group?
- In this case, what is the danger to have Quorum, Database, Logs on the
same group and then on the same physical disk?
We will buy disk, but we need to understand why we have to spend money.

Thanks for you rhelp.

Didier PARIS


"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le
message de news: eP3fkEJ2FHA.2792@xxxxxxxxxxxxxxxxxxxxxxx
>I take it the 36 RAID 1 is shared storage? Clustering treats partitions as
>one physical disk resource. Everything in the configuration you mentioned
>would reside in the Cluster Group only. You can have 5 partitions or only
>1, it does not matter to the cluster - they are all the same disk.
>
> You really need to buy more disks and create a new RAID array for SQL to
> use. Or two even to separate the Databases from the Logs.
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
>
>
> "Didier P" <didierp@xxxxxxxxxxxxxxxxx> wrote in message
> news:uA0wzmH2FHA.908@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi All,
>>
>> We are building a new cluster configuration based on the following
>> hardware :
>> - 2 HP proliant DL380
>> - disk array : 2 X 36Gb RAID-1
>> - disk partionning : 5 partitions : (1Gb for Quorum, 25Gb for Database,
>> and 3 others partitions for shared stockage)
>>
>> The W2K3 SP1 cluster has been installed using the following configuration
>> :
>> - quorum has been installed on default cluster group using the 1Gb
>> partition, but in fact the quorum is really attached to the RAID-1 disk
>>
>> We have to install the SQL server 2000 on this cluster. We have to create
>> a new virtual server.
>> To do that, do we have to create a new group using the 25Gb partition? In
>> this case this new group will be actually attached to the RAID-1 disk
>> which is already used by the quorum. It seems that it is not recommended.
>> Another solution could be to install SQL server on the default cluster
>> group. But it is also dangerous to do that.
>> Or third solution : it is to not configure in RAID-1 the disk array.
>>
>> What could be the best solution to use SQL Server 2000 on W2K3 SP1
>> cluster system with this basic hardware configuration?
>>
>> Regards
>>
>> Didier PARIS
>>
>>
>>
>>
>>
>>
>
>


.

Relevant Pages

  • SUMMARY: changed WWID on cluster member boot disk
    ... disk and quorum disk of a single-member cluster, ... I could no longer boot from the cluster disks, ... the pre-cluster stand-alone system disk; ... the root1_domain on LUN containing the member boot disk was found ...
    (Tru64-UNIX-Managers)
  • Re: Set up FTDATA on Failover Clustering
    ... Creating Databases or Changing Disk File Locations on a Shared ... Cluster Drive on Which SQL Server 2000 was not Originally Installed" ... If you have a secondary shared cluster disk AND if the SQL Server resource ...
    (microsoft.public.sqlserver.fulltext)
  • Sun Cluster 3.1 and 3510FC and Veritas and Failed Drive
    ... I have a 2 node cluster running Sun Cluster 3.1 ... with Sol 8 and Veritas VxVM and VxFS, I have a 3510fc with a controller ... These partitions were then presented to the cluster nodes ... So I have a disk I can use to replace it with... ...
    (SunManagers)
  • Re: Adding Virtual Print Server Resource No Physical Disk Appears Drop
    ... I duplicated the partitions in Virtual Server and as Jeff indicated only the ... Management and then Disk Management and see if you see the 2nd partition. ... Just created a two node cluster. ...
    (microsoft.public.windows.server.clustering)
  • Re: Cluster Groups & Quorum
    ... Until the cluster is established, all SAN disks appear as locally attached storage. ... is a SAN-based disk, ... Microsoft SQL Server MVP ... Why aren't you using a shared disk resource? ...
    (microsoft.public.sqlserver.clustering)
Loading