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