How to: Remove Physical Disk from SQL Cluster Group (If possible)

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



Hello,

I want to remove my backup raid container or x: drive from my sql
group because I don't want my sql service to fail as this volume has
had some problems with the hard drive firmware on the raid container.
I've tried to find out if this is possible to do and have not found
anything yet. I am hoping someone out there will have some thoughts
on this.

Basically, I have an active/passive win2k3 sp1 with sql 2005 sp1
clustered server on 2 dell 2850's and a 220s powervault that is having
problems with a raid container. The container has some drives that
have a timeout problem due to the firmware version (ATLAS15K2_73SCA
JNZY MAXTOR). The fix according to Dell is to flash the flash the
drives. The drives on the subsystem that are at risk are found mostly
under this raid container. My thought is that I can flash the drives
but also remove the container or volume's dependency in sql so in case
the volume fails or has problems the service continues to function
while I figure out how to deal with these bad drives/container/volume.

I have read somewhere that you can remove the "affect the group"
setting on the physical disk properties under the advanced menu but I
was wondering if there was another way that would be better.

Thanks to all for your comments.

.



Relevant Pages

  • Re: How to: Remove Physical Disk from SQL Cluster Group (If possible)
    ... As long as the SQL instance isn't actually USING the disk, you can remove the dependency from the other resources without stopping the SQL service. ... had some problems with the hard drive firmware on the raid container. ... The container has some drives that ...
    (microsoft.public.sqlserver.clustering)
  • Create a container in a pre-configured RAID?
    ... Is there any software that will allow me to configure a RAID container ... My two 80GB drives are configured as ... RAID1. ... Prev by Date: ...
    (microsoft.public.windows.server.sbs)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)
  • Re: Filegroup recommendation
    ... >>> filegroup, and the transaction logs into their own filegroup. ... >>> and multiple hard drives. ... In a multiple-processor system, SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Worst monday of my life - please help...
    ... If that's the case, restoring the SQL ... but it finally did install with a few hiccups. ... >> or just leave the mirrored drives in the server on the secondary IDE ... I decided it was time to re-add the mirror. ...
    (microsoft.public.windows.server.sbs)