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

On Jun 13, 8:53 am, horseradish <millar...@xxxxxxxxx> wrote:
As long as the SQL instance isn't actually USING the disk, you can
remove the dependency from the other resources (it may appear on more
than SQL server) without stopping the SQL service. Once the dependency
is gone, you can take it offline and it won't affect the group (manually
setting it offline is treated differently from a failure, and a failure
that moves the group won't result in it coming online automatically).

You will want it online and in maintenance mode (from the command line:
cluster <res> /maint:on) in order to upgrade the drive firmware. You can
leave it in the same group or move it to a different group (even to the
point of creating a temporary group for it) while you upgrade the
firmware. Make sure you take it OUT of maintenance mode when you're done
(although a reboot may be necessary for the drive & controller to
correctly handle the new firmware state).



Linchi Shea wrote:
If you have a SQL Server dependency on this drive, stop the SQL Server
resource, remove the dependency, and then bring online SQL Server. After
that, you can either uncheck the Affect the Group property of the disk
resource or move it to a different group.

Linchi

"Blackgoo" wrote:

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.- Hide quoted text -

- Show quoted text -

Can you elaborate on what you mean by "USING"? The drive is used for
sql backups but that is it. It is not in use for a majority of the
day, only when making normal or transactional backups of the database.

Also, Dell's drive fiirmware upgrade is done via an bootable iso that
would require me to shutdown one node and boot to the disk on the
other node to update the drives. The reason why I wanted to remove
the x drive from the cluster is that if there is a problem with the
upgrade, the sql server service wouldn't fail because of it. Make
sense? Given this, do I still need to put the clustering software in
maintenance mode or since the flash occurs outside Windows and
Clustering am I ok to not do it...?

Thanks.

.

Relevant Pages

  • Re: Checkpoint causes need for better IO subsystem?
    ... excellent articles on clustered index selection and its impact on ... clustered index sql kimberly tripp ... Microsoft SQL Server MVP ... the random write capability of the drives comes into play, ...
    (microsoft.public.sqlserver.tools)
  • RE: Trying to RESTORE a sql 2000 db on a different drive letter.
    ... During the installation of sql server, if you did not pick the d: ... the data drive or the system files drives, it will not have the necessary ... Right click on the database you want to restore. ...
    (microsoft.public.sqlserver.setup)
  • Re: New SQL Server 2000 installation
    ... a single IDE drive and 512MB RAM -- and don't have any performance issues. ... The PE1850 only holds two drives, so I'm stuck with a mirrored SCSI ... >> I'm going to be setting up a new SQL server and was hoping to get some ...
    (microsoft.public.sqlserver.setup)
  • Re: Log file partition
    ... I support the Professional Association for SQL Server ... Most are system databases which are in simple mode anyway. ... Three drives are for fault tolerance and performance. ...
    (microsoft.public.sqlserver.server)
  • Re: Server no longer on list
    ... Neither of those are on the PCs, only SQL service is ... SQLAgent$MICROSOFTSMLBIZ is set to manual, and is not started, yet these PCs ... Anyone hear of some component of windows update that installs SQL server ...
    (microsoft.public.access.adp.sqlserver)
Loading