Hi , Last week we have a server crash in the datacenter .
one of our customers use a SQL Database.
When I would restore / attach the mdf , I get a a lot of errors .
When we execute the following query :
DBCC CHECKDB (BPO, REPAIR_ALLOW_DATA_LOSS)
Msg 7985, Level 16, State 2, Line 1
System table pre-checks: Object ID 4. Could not read and latch page (1:148) with latch type SH. Check statement terminated due to unrepairable error.
DBCC results for 'Exp_0700SWPDeLoods'.
Msg 5233, Level 16, State 98, Line 1
Table error: alloc unit ID 262144, page (1:148). The test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. The values are 29362185 and -1.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'Exp_0700SWPDeLoods'.
We also try to update the status from the systables , also without any result
We hope someone could help us out .
When you need the mdf file , I could send you