>thnx fabio,
>
>only one problem, its a very big database so big i think it will take hours to check the db. Do you know if there are solutions to check just one table in a db knowing that the rest of the tables are ok ?
Kurt, if you have a bad page into a DB, YOU HAVE TO CHECK THE DB, FULLY!!
If a SQL index is corrupted, and the relational integrity is active,
using the db can destroy the db coherency.
Hovewer:
DBCC CHECKTABLE ('tableName', REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS)
A way can to be :
- recovery into a offline server,
- repair with CHECKDB,
- if found others fault pages, recovery the online db