up vote 0 down vote favorite
share [g+] share [fb]

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 ?

link|improve this 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
feedback

migrated from stackoverflow.com Nov 7 '10 at 19:24

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

closed as exact duplicate by Dennis Williamson, ErikA, John Gardeniers, splattne♦ Nov 8 '10 at 9:13

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

2 Answers

up vote 2 down vote

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.

link|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. – Randolph West Nov 8 '10 at 3:01
feedback
up vote 0 down vote

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/

link|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. – Randolph West Nov 8 '10 at 3:00
@Randolph - Thanks for noting that, I did added your suggestion now – Raymund Nov 8 '10 at 3:13
feedback

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