Skip to Content
0
Sep 22, 2011 at 08:58 AM

dbcc checkdb

465 Views

Hello!

I worked out sapnote 142731 but we are not able to restore, because the production has been working since two further days. Can anybody tells me how to repair the allocation errors?

Thank you in advance

Michael

The last checkdb give me this result:

dbcc checkdb (PL3)with no_infomsgs

Server: Msg 8905, Level 16, State 1, Line 1

Extent (1:1031296) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

Server: Msg 8905, Level 16, State 1, Line 1

Extent (1:1038336) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.

CHECKDB found 2 allocation errors and 0 consistency errors in database 'PL3'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PL3 ).