>Hi all,
>
>Yesterday we had a crash with our database server. At this moment we are up again for 99%. There is just one problem that is left. For one or another reason we have a table that isn't recoverd like it should be.
>
>Now when we launch querys or try the modify the table we are getting errors like :
>'I/O error (bad page ID) detected during read at offset 0x0000002c950000 in file 'C:\PROGRAMME\MICROSOFT SQL SERVER\MSSQL\DATA\MYDATABASE.MDF'
>
>Does somebody know how to solve this problem ?
>
>
>Thnx

* FIRST
DBCC CHECKDB ('MYDATABASE',REPAIR_REBUILD)
* IF FAIL
DBCC CHECKDB ('MYDATABASE',REPAIR_ALLOW_DATA_LOSS)