Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com 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 serverfault.com/questions/199138/repair-suspect-database –  gbn Nov 7 '10 at 19:07
add comment

2 Answers

Restore.

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
add comment

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/

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

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