repair suspect database
my sql server 2008 told me that you database is suspect and I can't see my tables or my data what should I do ?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
While this is going on, read Paul Randal's site: he wrote DBCC for Microsoft.
Basically you have a corrupt database: there are several solutions floating around on the internet but restoring from a good backup is usually best.
Hi here is a complete guide and explanation on how to go with reparing a suspect database, this happend to me several months ago and decided to document what I sepcifially made for those who might need -> http://anyrest.wordpress.com/2010/08/24/reparing-suspect-sql-database/