My sql server 2008 told me that you database is suspect and I can't see my tables or my data or use it what should I do ?
Tell me more
×
Server Fault is a question and answer site for
professional system and network administrators. It's 100% free, no registration required.
|
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. |
|||
|
|
|
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/ |
|||
|
|
