0

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 ?

Community
  • 1
salamonti
  • 131
  • 3
  • Put the database offline and restore from backup. This belongs to [serverfault](http://serverfault.com/). –  Nov 07 '10 at 18:33
  • Already asked on SF just now http://serverfault.com/questions/199138/repair-suspect-database – gbn Nov 07 '10 at 19:07

2 Answers2

2

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.

gbn
  • 6,079
  • 1
  • 18
  • 21
  • Seconded. As I commented on @Raymund's answer, you stand a chance of making a database inconsistent if you attempt a repair. –  Nov 08 '10 at 03:01
0

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/

Raymund
  • 101
  • 1
  • 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. –  Nov 08 '10 at 03:00
  • @Randolph - Thanks for noting that, I did added your suggestion now – Raymund Nov 08 '10 at 03:13
  • http://www.sqlskills.com/BLOGS/PAUL/category/Repair.aspx – gbn Nov 08 '10 at 05:48