Hello, our server hard disk crashed due to power failure and all the backups were on the hard disk. Before just before it did we had managed to copy the mdf file but power failed while copying the log file. The mdf can't be attached on a different machine now cos there was a transaction in progress when it was detached. So I created a new database, stopped the service and replaced the new mdf with the corrupt one and started the service again. Its state was Recovery_Pending.
It is in these power failure situations that people realise the importance of a UPS (uninterruptible power supply). You were moving the MDF, LDF to somewhere else on the same disk ? Hmm, you may have a torn page if you say you had a transaction in progress when detaching the MDF (which leads me to wonder why you would do this). Really these then call for restoring from backup, but if your backups were on the same disk then that is a lost cause. I am surprised that a power failure ( I assume loss of electricity is meant here) would cause the needle on a hard drive to crash into the media. Usually the circuit breakers and power strips would keep the surges from happening but I am thinking outloud now.
Sounds like there needs to be a lot of governance rules set up at your place.
----------------------------------------------------