Who never experienced a critical failure of some server that resulted in database corruption? There are times that the unthinkable happens, be it with physical or virtual servers, and there will always be a weaker link somewhere in the service chain. (Don’t talk to me about Windows 2000 clustering with SQL, please!)
Some other day I was doing a little of research in this subject of Disaster-Recovery and came across a great post. If I had access to these guides when my first experience with a missing log file happened… oh boy, it would have been a happy day.
Read it carefully, and save the commands in your heart. You probably won’t need them often, but when you do need it will be critical knowing them.
EMERGENCY-mode repair: the very, very last resort
cya!
The Lonely DBA 