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 ?
Database – repair suspect database
databasesql-server-2008
databasesql-server-2008
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 ?
Best Answer
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.