I'm just asking -- I've drunk the kool-aid that makes me believe that when a SQL Server database is running using the "full recovery model" (with log backups being taken regularly) that the only possible data loss that can occur (other than the situation where the disk holding the current log backup is physically damaged by the power outage) is that any transactions in progress at the time of the outage will be rolled back (but all that were successfully committed will be recovered).
Unless there is physical disk damage, when power is restored, isn't SQL Server supposed to be able to recover automatically? You say that it marked the database as "suspect". What did the SQL Server event log say was the cause of it being so marked? Did you make a copy of the database and log files as they were at that point and open a case with Microsoft to let them figure out why the recovery didn't happen? SQL Server -- I thought -- is very careful about the sequence in which it writes to the database file(s) and log file so that recovery is guaranteed.
Am I wrong that SQL Server is designed to handle exactly this situation 100.00% of the time??? Isn't it a bug -- or a hardware failure -- when it doesn't?
Even if SQL Server can't process the database and log files when it restarts (possibly due to disk damage), if you obtain functioning disk hardware, restore the most recent backup, and apply all subsequent log backups followed by the current live log file (if available), shouldn't that bring you to exactly the point of the last successfully committed transaction? If the current live log file isn't available, then you "only" get to the point of the most recent transaction log backup -- which in a busy site I would think would be maybe 10 minutes old, not hours.
I'm concerned that what happened to SO's database could happen to one of mine, so I'm wanting to know more than I do now about what exactly was wrong and whether MS has had a chance to see the problem "live" and as a result possibly make (some version of) SQL Server more robust in that situation.