Overview Encountering a corruption in a database is a rare thing. It can happen, however, most often due to faulty hardware or operational mistakes (like deleting a transaction log file).
More information I used to have some recommended steps in here, in case you run into a corrupt database. I've decided to instead point to other better and more elaborate resources for this. So, check out Brent's blog post, watch Paul's video and download his pdf-poster:
If you feel uncertain , I recommend letting MS Support hand-hold you through the steps appropriate for your particular situation. As you probably realized, Paul Randal is an authority on this topic. Check his blog for great information, examples etc.