How do I diagnose failed SCSI disk?

Posted on 2009-05-16
Medium Priority
Last Modified: 2013-11-05
I'd appreciate some advice re diagnosing and repairing/replacing a failed SCSI disk in an out-of-warranty generic Intel server running Windows Server 2003.  The machine runs SQL Server 2000, and I use it only for data analysis.  There are three Seagate Cheetahs on one channel of the motherboard SCSI controller, the 34GB boot disk and two 68GB disks.  The SQL data files that I'm actively using are on a 600GB MegaRAID SCSI RAID 10 array, and others (e.g., raw and outdated data) are on a 1TB ReadyNAS Duo (via NFS share).  One of the 68GB Cheetahs contains the SQL log files, and the other contain(ed) temporary working databases.

In preparation to replace a failing disk (one of those notorious 1TB Seagate Barracudas) in the ReadyNAS Duo, I decided to backup all of the databases on that device.  The next morning, I found that one of the 68GB Cheetahs, fortunately not the one containing the SQL log files, had disappeared from the server.  Looking in Disk Management, I saw that disk listed as missing/offline with status failed.

I tried reactivating the volume, but that did nothing.  Is there anything else that I can do to diagnose the disk before replacing it?

Based on what I've found on Experts Exchange, I gather that one possibility is a bad SCSI cable.  Given that the other two disks on that cable are OK, perhaps it's a loose connection.  Before replacing the disk, I'll try re-seating all of the connectors on that cable.  If that doesn't bring the disk back, I'll replace it, using the same ID for the new disk.

Does that sound reasonable?  What have I missed?
Question by:drjimcook
  • 3
  • 2

Accepted Solution

wfaleiro earned 2000 total points
ID: 24405042
Most probably the disk has gone bad. It is very rare for the cable from a server to just go faulty/loose unless you were working on it recently. The most obvious thing you would do is borrow a working cable from another system (not from this array on the server) and test the current disk with that. if it still appears offline, you got your answer.

If you have a alternate disk then that is even a better approach to fix. just try connecting it to the place where you have the disk listed as offline and check if it appears online or the raid rebuilding.


Author Comment

ID: 24408842
Thank you, Walter.  What puzzles me is that I saw no disk-failure-prediction warnings, and didn't see any bad sectors.  The disk was seemingly fine, and then it was gone.  OTOH, that machine did have major problems last summer, after a lightning spike that overwhelmed the UPS, and went back to the seller (sans disks) for a new motherboard.  Perhaps the circuit board on that drive was also damaged, but took another year to fail.  If that were the case, replacing the disk's board might bring it back, right?  Perhaps I'll play with it when I have some time.

While messing with this machine, I'm going to add a 176GB RAID 1 array for the database log files, and replace the boot disk with a new 73GB disk (using Symantec Ghost).  At least temporarily, I'll use the still-working 73GB disk to mirror the new boot disk.  I only have one remaining RAID channel.

Does that make sense?

Thanks again.  BTW, I'd like to award points after getting into the machine, which won't be until next weekend.

Expert Comment

ID: 24409029
Well as long as you have given a thought to the usage months/years ahead for space considerations its fine. I believe the raid controller does not support raid6.


Author Comment

ID: 24409309
That's a very good point, Walter.  Unfortunately, this is not a good time for me to buy a new machine.  Also, the motherboard, memory and one of the CPUs are just a year old, and the machine is otherwise adequate.  I'd like to make it work for another year or so.

I typically receive as much as 200GB raw data per project.  After initial analysis, I can usually move the raw data to the network or offline, and keep just aggregated data locally.  However, it does appear that I'll be getting more raw data soon than I have space for.  If that happens, I'm planning to buy a 3ware 9690SA-8E with four 1TB Western Digital RE3 SATA II disks as RAID 10 in an external enclosure.  That'll cost less than $2K, and I can use the disks in the next machine.


Author Comment

ID: 24532621
Well, I finally made time to work on the machine.  And amazingly, the disk came back after I reseated the power and data connections.  I still replaced it, however.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Solid State (Hard) Drives aka SSD began to evolve in the computer industry recently. As the name suggests, there are no moving parts in the drives. The drive uses microchip memory store the data, as opposed to the spinning disks of a traditional HDD…
Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month14 days, 23 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question