Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ?

share|improve this question

migrated from Nov 7 '10 at 19:24

This question came from our site for professional and enthusiast programmers.

marked as duplicate by Dennis Williamson, EEAA, John Gardeniers, splattne Nov 8 '10 at 9:13

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Put the database offline and restore from backup. This belongs to serverfault. – Frédéric Hamidi Nov 7 '10 at 18:33
Already asked on SF just now – gbn Nov 7 '10 at 19:07


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.

share|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 ->

share|improve this answer
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.