Possible Duplicate:
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 ?



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.

| improve this answer | |
  • Seconded. As I commented on @Raymund's answer, you stand a chance of making a database inconsistent if you attempt a repair. – user3914 Nov 8 '10 at 3:01

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/

| improve this answer | |
  • 1
    Since your page includes the REPAIR_ALLOW_DATA_LOSS command, I think it's important to add a very large disclaimer that there is potential for data loss if you use this. – user3914 Nov 8 '10 at 3:00
  • @Randolph - Thanks for noting that, I did added your suggestion now – Raymund Nov 8 '10 at 3:13

Not the answer you're looking for? Browse other questions tagged or ask your own question.