"What to do when the database is corrupt.
- Don't panic
- Don't detach the database
- Don't restart SQL
- Don't just run repair.
- Run an integrity check
- Afterwards, do a root-cause analysis"
And if all else fails, there's a product called Recovery for SQL Server to help fix your files.