>Check Re: I/O error (bad page ID) detected during read at offset Thread #1008806 Message #1008838
>
>>I did a dbcc checkdb and found problems with 1 table. When I try to make a temp copy to another table I get this error:
>>
>>Server: Msg 823, Level 24, State 2, Line 1
>>I/O error (bad page ID) detected during read at offset 0x000001d9bec000 in file 'g:\mssql\data\ecash_prod_Data.mdf'.
>>
>>Connection Broken
>>
>>What options do I have to attempt to repait this sucker?
>>
>>TIA
>>
>>__Stephen


Well You have to put the db into single user mode to do those REPAIR(s), so I restored an earlier backup to that server and copied all the rows to the troubled db. I was then able to pull off the difference between tables, drop the problem table and insert from my "fixed" table. Recreated the indexes and all was good.

__Stephen