Could not believe it today when THE SAME THING happened to me again, as has been happening for the past 2 months... nearly identical to this thread's OP's experience.
I had just awakened my ASUS P5Q3 system from hibernation (which I place the system in before walking away, anytime I know I'm not going to need it again for hours or longer) and everything started up fine. Then I got into my email program, received new mail, and clicked on a "+" to open up a thread for which there was a new reply.
Instantly, the "+" expansion process froze, a blank line appeared on the screen, and my system was seemingly frozen... except that the mouse continued to work perfectly. But I could not get into anything else, or open anything else, or elicit any response from the system.
I had a bad feeling about the fact that probably the drive and/or SATA connector/cable I'd been fighting with for 2 months now had probably flaked out again.
Anyway, I took my usual "kick start" approach, of powering the machine off (holding the ON/OFF button for 4 seconds), pulling the power cord out of the machine for a while, plugging the power cord back in, and then restarting the system.
Not surprisingly, there was yet another one of the now-familiar BIOS-related indications that one of my two SATA drives was not functioning correctly... BUT THIS TIME IS WAS MY OTHER ONE!!! Unfortunately, this is not hard disk #2 where I have Win7 installed, but hard disk #1 where I have WinXP installed (and which contains the "active" WinXP partition where boot manager for WinXP and Win7 lives).
This is the same problem as before, but this time for my second SATA drive! Note that throughout all of this my third U320 SCSI drive (on an Adaptec 29320-alp controller) has continued to perform flawlessly. In fact, in my 17 years of building/playing with my PC's, I've never had any trouble with SCSI drives. It's only in the past two years that I've started phasing them out and replacing them with SATA drives that I have begun to see these odd SATA-related anomalies... at least on this one ASUS P5Q3 machine. Fortunately, no such anomalies have ever occurred on my other Supermicro C2SBX HTPC machine (which now has three large SATA drives along with one remaining large U320 SCSI drive on an Adaptec 39320-r controller).
Anyway, quite stunned but undaunted by the now-familiar SATA drive/connector/cable failure, I took my now-familiar second-level attempt at recovery. I once again opened the case, removed and reseated the SATA cable onto the drive connector, pulled and reseated the other end of the SATA cable onto the motherboard connector (without changing SATA ports, just removing and reseating the cable), and then closed everything up and restarted the machine.
Not surprisingly (and very thankfully), now the BIOS had no trouble talking to that hard disk #1 and I was once again able to get to boot manager (from the "active" partition on that drive) and boot to Win7.
Once again... case closed, disaster averted. However I'm now suspicious that the P5Q3 motherboard itself, and its SATA controller, which is perhaps at fault.
My nephew has advised me that there is a known defect in Intel's Southbridge chipset which is at fault, and that there is a "recall" announced. My P5Q3 uses an ICH10R Southbridge chipset to support my 6 SATA ports. I have been unable to find out for myself what he's talking about, but I will phone him today to ask about it.
[EDIT: spoken with him now, and it turns out to be Sandy Bridge, not Southbridge, where this SATA recall issue applies)
Anyway, for me it doesn't now appear to be drive-related, or SATA-connector related, or SATA-cable related, as the same problem has now occurred on BOTH of the SATA drives in my machine, which have been plugged into 4 of the 6 connectors on the board, all of which have begun to "fail" the same way over the past 2 months.
Very suspicious.