Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql server cluster using raid 0+1

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-17 : 07:31:08
Mike M writes "SQLTeam,

We need a SQL Server solution that provides the highest degree of availability. At this point, I have implemented a two-node, active/passive sql cluster, using a RAID 5 shared disk resource. I will be implementing log shipping to another site using the same configuration. We are using SCSI RAID controllers that have at least two channels to the RAID backbone. We have 10 disks on a Dell PowerVault. 2 disks in the Quorum, 2 disks for the log (and tempdb), 6 disks for the RAID 5 data files. From what I understand, the "single point" of failure here is the RAID backbone.

Question: If I implement RAID 0+1 (by adding another 10 disks), can this overcome the single point of failure mentioned above? In other words, If RAID 0+1 is implemented, are the mirrored arrays on two different RAID backbones?

Any comment, discussion, whitepapers, or links is appreciated.

Thanks, Mike M"
   

- Advertisement -