Disk failure and DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS problem: "The repair level on th

Hello,
Hard disk started with bad sectors, it was noticed only when it was too
late, i.e. when the backup contained corrupted data (actually,
truncated, as BCP failed midway through) as well as the master
database. Database works, but when certain data is accessed, a SQL
error occurs. No summarising SQL queries work as they have to go
through corrupted data as well as through valid data.
I just ran:
DBCC CHECKDB('MYDB','REPAIR_ALLOW_DATA_LOSS')
It is NOT repairing anything. It's saying:
"The repair level on the DBCC statement caused this repair to be
bypassed."
That contadicts my command. Can anyone tell me what I'm doing wrong?
Below is portion of the output.
THANK YOU VERY MUCH FOR ANY HELP. BECAUSE EVEN THE BACKUP IS CORRUPTED,
I AM DESPERATE. Ideally, if at all possible, I would like to fix
this ASAP, so waiting for a week for PSS is the last resort.
DBCC results for 'Transactions'.
Msg 8928, Level 16, State 1, Server SQLSVR, Line 1
Object ID 205243786, index ID 0: Page (1:259285) could not be
processed. See
other errors for details.
The repair level on the DBCC statement caused this repair to be
bypassed.
Msg 8941, Level 16, State 102, Server SQLSVR, Line 1
Table error: Object ID 205243786, index ID 0, page (1:259285). Test
(sorted
[i].offset >= PAGEHEADSIZE) failed. Slot 9, offset 0x1 is invalid.
The repair level on the DBCC statement caused this repair to be
bypassed.
Table error: Object ID 205243786, index ID 0, page (1:259285). Test
(sorted[i].o
ffset >= max) failed. Slot 0, offset 0x9 overlaps with the prior row.
The
repair level on the DBCC statement caused this repair to be
bypassed.
Msg 8928, Level 16, State 1, Server SQLSVR, Line 1
Object ID 205243786, index ID 0: Page (1:259286) could not be
processed. See
other errors for details.
The repair level on the DBCC statement caused this repair to be
bypassed.
Msg 8928, Level 16, State 1, Server SQLSVR, Line 1
Object ID 205243786, index ID 0: Page (1:259287) could not be
processed. See
other errors for details.
The repair level on the DBCC statement caused this repair to be
bypassed.
Msg 8928, Level 16, State 1, Server SQLSVR, Line 1
Object ID 205243786, index ID 0: Page (1:259288) could not be
processed. See
other errors for details.
...
Hi
see this link:
http://support.microsoft.com/default...b;en-us;826436
I hope this will be useful for yousql