Some of theses solutions are built upon common PLCs but some are built as standalone solutions when I/O are simple enough (modbus mainly, RS232/422/485, ethernet/IP, controlnet, ...). Seen lot of them in breeding nutrition management systems, in-house developped processes, ...

High school students !? You are more capable than most of adults from my country, even "of the trade" if I might say.

We require organic oil !

ECC unbuffered DIMMs (9 memory chips per side, no reg buffer/controller) is less available, quite widely used on level entry systems and thus costs a lot more even second hand.

I sold 7,2 Kg of DDR1/2/3 sticks two month ago, for gold recovery. As well as expansion cards, hdd PCBs and a few other things. Got about $600 from this.

(Nice job, seriously)

West EU here, bought a new, architecturally wrong (yikes) house in 2012. I knew its conception would spell trouble, and sadly I was not disappointed on this part almost right off the bat. But the location and the price (right on the aftermath of the 2008 financial crisis and economical fallout / market bottom) were good.

After 14 years it cost an average of $130 per month on maintenance, mainly to correct on multiple occasion the conception issues aformentioned after the 10y warranty. Utilities are about $170 per month. And taxes are now about $1700 per year (rise 3-4% every year)

This $250k purchase must have cost less than $2k in fees, the credit was... well no credit. Spent almost 100% of my savings except some cash for my business. On the overall this house cost me less than $500 per month so far. Not really surprising for a new house, certainly.

And its market value rose by 60% in 14 years.

Yep, ownership is (was ?) very profitable in the west EU, mind the location.

SATA disk are indeed generally more predictable failure-wise. Most issues are related to a failing head stack assembly. Rarely platter demagnetization for some disks (Toshiba laptop).

Other failure issues are usually related to a friggin' manufactured firmware issue from Dell, HP or Lenovo corp.

Disk errors logged in the system event log are from the I/O layer, low-level class driver (msahci.sys) / filter drivers. See Windows Storage Driver Architecture : https://learn.microsoft.com/en-us/windows-hardware/drivers/s...

A disk error of this type showing in the event log must immediately be treated as an actual disk issue. This is a low level issue below the actual filesystem and application/services. Seems here the .mdf/ldf of your SQL database used one or more bad sectors on the disk surface.

Your disk seems to be only one on the system, so the first thing to do is check SMART status, for example with Crystaldiskinfo (the most used and user-friendly free portable windows software).

It would very probably have shown a warning state for the internal disk, with probably one or more (judging the quantity of disk error entries in your log) for Attribute C5 "Current Pending sectors" and probably some in Att 05 - "Reallocated sectors count" and/or Att C4 - "Realloc event Count".

Second thing to do is trying to backup your data as fast as possible. In your case related to a Ms SQL database, trying to dump it / backup first was the good move. Sadly (DR pro experience here), weak surface / failing Head Stack Assembly of a traditionnal HDD from most vendors has more difficulties reading correctly a sector than writing it.

If the dump/backup fails, the second choice would have be to try to a sector-to-sector dump approach of the whole disk, with either a online (from OS) software capable of reading sectors from the boot disk (didn't try if HDD Raw Copy Tool 2.6 supports it), or an offline solution like Clonezilla, Acronis True Image, Aomei backupper, etc. But offline solution means offline computer and service...

I didn't exactly understood if you had an actual backup of the data or an image of the whole disk. Considering the critical usage of this station, you should have both running : daily data backup or more + up-to-date disk image ready. whatever the type of disk (HDD/SSD). And a spare, identical computer.

As for repair of HDDs "weak sectors" (meaning Current Pending Sectors), it is indeed possible, often with complete data recovery. If not, the sector will be left as is, or may be remapped if written to 0 (it will then shift from Current pending to realloc sector count).

Hard disk Sentinel Pro as such features (Disk repair, Quick Fix), it works quite well. The result vary greatly from one type of failure to another, as from one disk maker to another.

Note that if the SMART shows more than a little dozen of sectors, the head (amp/preamp) is probably failing, making weaker magnetically-wise sectors too difficult to read and/or write. In this case, the count of current and remapped increases every repair/check pass made by the tools. In this case, the drive is toast and must be replaced ASAP.

SSD are a complete different case for repair.

A older autonomous tool, Spinrite, was specialized for this usage (accurate recovery of data), but veeeeery slow.

RAID pertinence : fortunately, it is an expecteed case as most SATA disks are prone to HSA failure before not initialyzing at all. A RAID 1 mirror would have protected you from a mirrored defect accross the two disks.

The RAID controller (true hardware controller like LSI/Avago or Microsemi) or even fake raid like Intel RST / VROC maintain data integrity accross the array's disks. The defective disk will raise bad blocks (that will get marked in metadata of the Raid Volume), but the others disks are fine and the data can be read safely. If too many errors are reported on a disk (very few in fact on most controllers), it will be labelled as failed and taken down from the array.

Quite a perfect neutralization scheme in this "hunt for self-actualisation".

That's why the display of commitment shown in this thread hurts.

Or even worse : Maxio