Hi,
I have an SQL 2008R2 DB and I had to execute the command to repair with data loss and I need your help to interpret the result, I dont know how much information was lost and of what kind, the db works apparently well but I'm not sure if put it on production or not, please see the attached word fi.
DBCC results for '006'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:4442349) contains an incorrect page ID in its page header. The PageId in the page header = (0:0). The error has been repaired.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB fixed 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 4 consistency errors in database '006'.
CHECKDB fixed 0 allocation errors and 4 consistency errors in database '006'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.