April 22, 2008 at 12:14 pm
We've had this issue for a while and I'd like to know if there's a way to tell what data might be lost if we use the repair_allow_data_loss option. Here's the output from the Checkdb (if it's waay too much info let me know and I'll wipe out what's not necessary :unsure: ):
Job 'Cabinet CheckDB' : Step 1, 'Step1' : Began Executing 2008-04-20 04:00:01
Msg 8905, Sev 16: Extent (3:337432) in database ID 8 is marked allocated in the GAM, but no SGAM or IAM has allocated it. [SQLSTATE 42000]
Msg 2536, Sev 16: DBCC results for 'cabinet'. [SQLSTATE 01000]
Msg 8954, Sev 16: CHECKDB found 1 allocation errors and 0 consistency errors not associated with any single object. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysobjects'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1400 rows in 24 pages for object 'sysobjects'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysindexes'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 923 rows in 41 pages for object 'sysindexes'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syscolumns'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 5742 rows in 93 pages for object 'syscolumns'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'systypes'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 26 rows in 1 pages for object 'systypes'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syscomments'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1258 rows in 421 pages for object 'syscomments'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfiles1'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 6 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'syspermissions'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1343 rows in 6 pages for object 'syspermissions'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysusers'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 28 rows in 1 pages for object 'sysusers'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysproperties'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'sysproperties'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysdepends'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 8604 rows in 49 pages for object 'sysdepends'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysreferences'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 44 rows in 1 pages for object 'sysreferences'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfulltextcatalogs'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 1 pages for object 'sysfulltextcatalogs'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfulltextnotify'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'sysfulltextnotify'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysfilegroups'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1 rows in 1 pages for object 'sysfilegroups'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'SEGMENT_DATA'. [SQLSTATE 01000]
There are 1622 rows in 51 pages for object 'SEGMENT_DATA'. [SQLSTATE 01000]
DBCC results for 'user_productivity'. [SQLSTATE 01000]
There are 60120 rows in 802 pages for object 'user_productivity'. [SQLSTATE 01000]
DBCC results for 'HR_ADI_WORK'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_ADI_WORK'. [SQLSTATE 01000]
DBCC results for 'CAB_DEL_ITEMS'. [SQLSTATE 01000]
There are 173520 rows in 3146 pages for object 'CAB_DEL_ITEMS'. [SQLSTATE 01000]
DBCC results for 'HR_CAB_DEL_ITEMS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_CAB_DEL_ITEMS'. [SQLSTATE 01000]
DBCC results for 'FOLLOW_UP'. [SQLSTATE 01000]
There are 4745 rows in 4027 pages for object 'FOLLOW_UP'. [SQLSTATE 01000]
DBCC results for 'HR_CAB_HOLD'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_CAB_HOLD'. [SQLSTATE 01000]
DBCC results for 'HR_Merge_Work'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_Merge_Work'. [SQLSTATE 01000]
DBCC results for 'ROI_Billing_Type_Tier'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ROI_Billing_Type_Tier'. [SQLSTATE 01000]
DBCC results for 'TRANS_LIST'. [SQLSTATE 01000]
There are 470 rows in 4 pages for object 'TRANS_LIST'. [SQLSTATE 01000]
DBCC results for 'TRANS_SEGMENTS'. [SQLSTATE 01000]
There are 210 rows in 2 pages for object 'TRANS_SEGMENTS'. [SQLSTATE 01000]
DBCC results for 'Domain_File'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object 'Domain_File'. [SQLSTATE 01000]
DBCC results for 'ROI_Req_Encounter'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ROI_Req_Encounter'. [SQLSTATE 01000]
DBCC results for 'ROI_Req_Release_Page'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'ROI_Req_Release_Page'. [SQLSTATE 01000]
DBCC results for 'WsStudyGroups'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'WsStudyGroups'. [SQLSTATE 01000]
DBCC results for 'StudyDescGroups'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'StudyDescGroups'. [SQLSTATE 01000]
DBCC results for 'ROI_Request_Page'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ROI_Request_Page'. [SQLSTATE 01000]
DBCC results for 'Users_Domain'. [SQLSTATE 01000]
There are 5685 rows in 36 pages for object 'Users_Domain'. [SQLSTATE 01000]
DBCC results for 'ACCESSION_DUID'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ACCESSION_DUID'. [SQLSTATE 01000]
DBCC results for 'Attach_Dir'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Attach_Dir'. [SQLSTATE 01000]
DBCC results for 'ACTIONS'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object 'ACTIONS'. [SQLSTATE 01000]
DBCC results for 'Attachments'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Attachments'. [SQLSTATE 01000]
DBCC results for 'ACTIVITY'. [SQLSTATE 01000]
There are 11 rows in 9 pages for object 'ACTIVITY'. [SQLSTATE 01000]
DBCC results for 'SQL_FRAGMENTS'. [SQLSTATE 01000]
There are 259 rows in 11 pages for object 'SQL_FRAGMENTS'. [SQLSTATE 01000]
DBCC results for 'AGENTS'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object 'AGENTS'. [SQLSTATE 01000]
DBCC results for 'Wfe_DocNamesRecordViews'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_DocNamesRecordViews'. [SQLSTATE 01000]
DBCC results for 'DISK_TABLE'. [SQLSTATE 01000]
There are 1097 rows in 22 pages for object 'DISK_TABLE'. [SQLSTATE 01000]
DBCC results for 'AIS_List'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'AIS_List'. [SQLSTATE 01000]
DBCC results for 'Wfe_Document_Names'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_Document_Names'. [SQLSTATE 01000]
DBCC results for 'Wfe_DocumentDomain'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'Wfe_DocumentDomain'. [SQLSTATE 01000]
DBCC results for 'ARCHIVE_WORK'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ARCHIVE_WORK'. [SQLSTATE 01000]
DBCC results for 'AUTYPE_FILE'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'AUTYPE_FILE'. [SQLSTATE 01000]
DBCC results for 'BASIS'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object 'BASIS'. [SQLSTATE 01000]
DBCC results for 'MVPrefetchSpec'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'MVPrefetchSpec'. [SQLSTATE 01000]
DBCC results for 'CAB_HOLD'. [SQLSTATE 01000]
There are 130 rows in 129 pages for object 'CAB_HOLD'. [SQLSTATE 01000]
DBCC results for 'MVRetrieve'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'MVRetrieve'. [SQLSTATE 01000]
DBCC results for 'Wfe_DocumentDomainIndex'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_DocumentDomainIndex'. [SQLSTATE 01000]
DBCC results for 'CALCTABLE'. [SQLSTATE 01000]
There are 8 rows in 1 pages for object 'CALCTABLE'. [SQLSTATE 01000]
DBCC results for 'ASSIGNMENTSold'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ASSIGNMENTSold'. [SQLSTATE 01000]
DBCC results for 'CAT_FILE'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'CAT_FILE'. [SQLSTATE 01000]
DBCC results for 'Wfe_Domain'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'Wfe_Domain'. [SQLSTATE 01000]
DBCC results for 'COLD_DIRECTORIES'. [SQLSTATE 01000]
There are 21 rows in 2 pages for object 'COLD_DIRECTORIES'. [SQLSTATE 01000]
DBCC results for 'MI_ORPHANED_IMAGES'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'MI_ORPHANED_IMAGES'. [SQLSTATE 01000]
DBCC results for 'COLD_FIELDS'. [SQLSTATE 01000]
There are 295 rows in 8 pages for object 'COLD_FIELDS'. [SQLSTATE 01000]
DBCC results for 'STUDY'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'STUDY'. [SQLSTATE 01000]
DBCC results for 'COLD_FONTS'. [SQLSTATE 01000]
There are 5 rows in 2 pages for object 'COLD_FONTS'. [SQLSTATE 01000]
DBCC results for 'COLD_FORMS'. [SQLSTATE 01000]
There are 134 rows in 10 pages for object 'COLD_FORMS'. [SQLSTATE 01000]
DBCC results for 'CABINET_XREF'. [SQLSTATE 01000]
There are 1207 rows in 71 pages for object 'CABINET_XREF'. [SQLSTATE 01000]
DBCC results for 'SERIES'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'SERIES'. [SQLSTATE 01000]
DBCC results for 'COLD_MASTER'. [SQLSTATE 01000]
There are 134 rows in 3 pages for object 'COLD_MASTER'. [SQLSTATE 01000]
DBCC results for 'Defagingcount'. [SQLSTATE 01000]
There are 1843 rows in 28 pages for object 'Defagingcount'. [SQLSTATE 01000]
DBCC results for 'COLD_PHYSICIAN_XREF'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'COLD_PHYSICIAN_XREF'. [SQLSTATE 01000]
DBCC results for 'SQLCriteria'. [SQLSTATE 01000]
There are 1 rows in 475 pages for object 'SQLCriteria'. [SQLSTATE 01000]
DBCC results for 'COLD_SIGNATURES'. [SQLSTATE 01000]
There are 134 rows in 2 pages for object 'COLD_SIGNATURES'. [SQLSTATE 01000]
DBCC results for 'Wfe_DomainDocNames'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'Wfe_DomainDocNames'. [SQLSTATE 01000]
DBCC results for 'MI_IMAGES'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'MI_IMAGES'. [SQLSTATE 01000]
DBCC results for 'Custom_Definition'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Custom_Definition'. [SQLSTATE 01000]
DBCC results for 'Rpt_MultiFacility'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Rpt_MultiFacility'. [SQLSTATE 01000]
DBCC results for 'Wfe_DomainIndex'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'Wfe_DomainIndex'. [SQLSTATE 01000]
DBCC results for 'DEFAGING'. [SQLSTATE 01000]
There are 22 rows in 1 pages for object 'DEFAGING'. [SQLSTATE 01000]
DBCC results for 'ROI_Autype_File'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'ROI_Autype_File'. [SQLSTATE 01000]
DBCC results for 'ASSIGNMENTS_OLD'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'ASSIGNMENTS_OLD'. [SQLSTATE 01000]
DBCC results for 'DEFAGING_DETAIL'. [SQLSTATE 01000]
There are 66 rows in 1 pages for object 'DEFAGING_DETAIL'. [SQLSTATE 01000]
DBCC results for 'MI_Equipment'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'MI_Equipment'. [SQLSTATE 01000]
DBCC results for 'DEPT_FILE'. [SQLSTATE 01000]
There are 107 rows in 1 pages for object 'DEPT_FILE'. [SQLSTATE 01000]
DBCC results for 'trans_actions'. [SQLSTATE 01000]
There are 230 rows in 2 pages for object 'trans_actions'. [SQLSTATE 01000]
DBCC results for 'Wfe_ExtensionType'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'Wfe_ExtensionType'. [SQLSTATE 01000]
DBCC results for 'DOCUMENT_NAMES'. [SQLSTATE 01000]
There are 910 rows in 43 pages for object 'DOCUMENT_NAMES'. [SQLSTATE 01000]
DBCC results for 'trans_table_actions'. [SQLSTATE 01000]
There are 230 rows in 2 pages for object 'trans_table_actions'. [SQLSTATE 01000]
DBCC results for 'Wfe_Groups'. [SQLSTATE 01000]
There are 68 rows in 2 pages for object 'Wfe_Groups'. [SQLSTATE 01000]
DBCC results for 'DOCUMENT_STATISTICS'. [SQLSTATE 01000]
There are 438121 rows in 4792 pages for object 'DOCUMENT_STATISTICS'. [SQLSTATE 01000]
DBCC results for 'trans_cold_actions'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'trans_cold_actions'. [SQLSTATE 01000]
DBCC results for 'Wfe_GroupsActivities'. [SQLSTATE 01000]
There are 19772 rows in 301 pages for object 'Wfe_GroupsActivities'. [SQLSTATE 01000]
DBCC results for 'DOCUMENT_SUCCESSION'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'DOCUMENT_SUCCESSION'. [SQLSTATE 01000]
DBCC results for 'trans_action_indexes'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'trans_action_indexes'. [SQLSTATE 01000]
DBCC results for 'ERROR_LOG'. [SQLSTATE 01000]
There are 110184 rows in 3936 pages for object 'ERROR_LOG'. [SQLSTATE 01000]
DBCC results for 'Wfe_GroupsRecordViews'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'Wfe_GroupsRecordViews'. [SQLSTATE 01000]
DBCC results for 'FACILITY_FILE'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'FACILITY_FILE'. [SQLSTATE 01000]
DBCC results for 'Documents'. [SQLSTATE 01000]
There are 21572237 rows in 638461 pages for object 'Documents'. [SQLSTATE 01000]
DBCC results for 'FAXES'. [SQLSTATE 01000]
There are 305 rows in 4 pages for object 'FAXES'. [SQLSTATE 01000]
DBCC results for 'Wfe_GroupsUsers'. [SQLSTATE 01000]
There are 334 rows in 5 pages for object 'Wfe_GroupsUsers'. [SQLSTATE 01000]
DBCC results for 'FILING_TEMPLATE'. [SQLSTATE 01000]
There are 62 rows in 1 pages for object 'FILING_TEMPLATE'. [SQLSTATE 01000]
DBCC results for 'ROI_Disposition_Reason'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object 'ROI_Disposition_Reason'. [SQLSTATE 01000]
DBCC results for 'Wfe_NextValue'. [SQLSTATE 01000]
There are 23 rows in 1 pages for object 'Wfe_NextValue'. [SQLSTATE 01000]
DBCC results for 'Wfe_Profile'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_Profile'. [SQLSTATE 01000]
DBCC results for 'Versions'. [SQLSTATE 01000]
There are 21527454 rows in 102913 pages for object 'Versions'. [SQLSTATE 01000]
DBCC results for 'LOCATIONTOAIS'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'LOCATIONTOAIS'. [SQLSTATE 01000]
DBCC results for 'Wfe_RecordViews'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'Wfe_RecordViews'. [SQLSTATE 01000]
DBCC results for 'Locales'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'Locales'. [SQLSTATE 01000]
DBCC results for 'Pages'. [SQLSTATE 01000]
There are 52714581 rows in 518849 pages for object 'Pages'. [SQLSTATE 01000]
DBCC results for 'NextValue'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'NextValue'. [SQLSTATE 01000]
DBCC results for 'Wfe_RuleParameters'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_RuleParameters'. [SQLSTATE 01000]
DBCC results for 'Not_Accept'. [SQLSTATE 01000]
There are 10 rows in 1 pages for object 'Not_Accept'. [SQLSTATE 01000]
DBCC results for 'ORDERS'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ORDERS'. [SQLSTATE 01000]
DBCC results for 'OUTBOUND_EVENT_Q'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'OUTBOUND_EVENT_Q'. [SQLSTATE 01000]
DBCC results for 'Wfe_Rules'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_Rules'. [SQLSTATE 01000]
DBCC results for 'Override_Reasons'. [SQLSTATE 01000]
There are 30 rows in 2 pages for object 'Override_Reasons'. [SQLSTATE 01000]
DBCC results for 'Wfe_SQLRules'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_SQLRules'. [SQLSTATE 01000]
DBCC results for 'PAYOR_FILE'. [SQLSTATE 01000]
There are 86 rows in 2 pages for object 'PAYOR_FILE'. [SQLSTATE 01000]
DBCC results for 'User_Worklist_Pref'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'User_Worklist_Pref'. [SQLSTATE 01000]
DBCC results for 'PHYSICIAN_GROUP_FILE'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'PHYSICIAN_GROUP_FILE'. [SQLSTATE 01000]
DBCC results for 'temp_images2'. [SQLSTATE 01000]
There are 18136 rows in 234 pages for object 'temp_images2'. [SQLSTATE 01000]
DBCC results for 'Print_Access'. [SQLSTATE 01000]
There are 3334 rows in 19 pages for object 'Print_Access'. [SQLSTATE 01000]
DBCC results for 'PRINTERS'. [SQLSTATE 01000]
There are 87 rows in 2 pages for object 'PRINTERS'. [SQLSTATE 01000]
DBCC results for 'PRODUCTIVITY'. [SQLSTATE 01000]
There are 2768 rows in 31 pages for object 'PRODUCTIVITY'. [SQLSTATE 01000]
DBCC results for 'App_Documents'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'App_Documents'. [SQLSTATE 01000]
DBCC results for 'User_Worklist_Pref_Column'. [SQLSTATE 01000]
There are 16 rows in 1 pages for object 'User_Worklist_Pref_Column'. [SQLSTATE 01000]
DBCC results for 'PTTYPE_FILE'. [SQLSTATE 01000]
There are 34 rows in 1 pages for object 'PTTYPE_FILE'. [SQLSTATE 01000]
DBCC results for 'wfe_prefetch'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'wfe_prefetch'. [SQLSTATE 01000]
DBCC results for 'PURPOSES'. [SQLSTATE 01000]
There are 29 rows in 2 pages for object 'PURPOSES'. [SQLSTATE 01000]
DBCC results for 'wfe_temp_prefetch'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'wfe_temp_prefetch'. [SQLSTATE 01000]
DBCC results for 'Cabinet_PRE'. [SQLSTATE 01000]
There are 0 rows in 14129 pages for object 'Cabinet_PRE'. [SQLSTATE 01000]
DBCC results for 'QUALIFIERS'. [SQLSTATE 01000]
There are 101 rows in 2 pages for object 'QUALIFIERS'. [SQLSTATE 01000]
DBCC results for 'Emp_Documents'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'Emp_Documents'. [SQLSTATE 01000]
DBCC results for 'Modules_File'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object 'Modules_File'. [SQLSTATE 01000]
DBCC results for 'Wfe_TypeAssociation'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'Wfe_TypeAssociation'. [SQLSTATE 01000]
DBCC results for 'RECORD_CONTENT'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'RECORD_CONTENT'. [SQLSTATE 01000]
DBCC results for 'RECORD_VIEWS_DOMAIN'. [SQLSTATE 01000]
There are 29771 rows in 376 pages for object 'RECORD_VIEWS_DOMAIN'. [SQLSTATE 01000]
DBCC results for 'MARK_FOR_PURGE_ROLLBACK'. [SQLSTATE 01000]
There are 9 rows in 3 pages for object 'MARK_FOR_PURGE_ROLLBACK'. [SQLSTATE 01000]
DBCC results for 'Wfe_UsersActivities'. [SQLSTATE 01000]
There are 966 rows in 16 pages for object 'Wfe_UsersActivities'. [SQLSTATE 01000]
DBCC results for 'REJECT_FILE'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'REJECT_FILE'. [SQLSTATE 01000]
DBCC results for 'HR_Versions'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_Versions'. [SQLSTATE 01000]
DBCC results for 'ASSIGNING_AUTHORITY'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'ASSIGNING_AUTHORITY'. [SQLSTATE 01000]
DBCC results for 'REQUESTOR_DEF'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'REQUESTOR_DEF'. [SQLSTATE 01000]
DBCC results for 'Wfe_UsersRecordViews'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'Wfe_UsersRecordViews'. [SQLSTATE 01000]
DBCC results for 'REQUESTS'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'REQUESTS'. [SQLSTATE 01000]
DBCC results for 'HR_Pages'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_Pages'. [SQLSTATE 01000]
DBCC results for 'RETRIEVE'. [SQLSTATE 01000]
There are 136581 rows in 15006 pages for object 'RETRIEVE'. [SQLSTATE 01000]
DBCC results for 'WKfields'. [SQLSTATE 01000]
There are 10 rows in 1 pages for object 'WKfields'. [SQLSTATE 01000]
DBCC results for 'RQ_DETAIL'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'RQ_DETAIL'. [SQLSTATE 01000]
DBCC results for 'UserGroups_File'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object 'UserGroups_File'. [SQLSTATE 01000]
DBCC results for 'WQ_ALERTS'. [SQLSTATE 01000]
There are 1 rows in 2 pages for object 'WQ_ALERTS'. [SQLSTATE 01000]
DBCC results for 'RQTYPE_FILE'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'RQTYPE_FILE'. [SQLSTATE 01000]
DBCC results for 'HR_APPLICANT_DATA'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_APPLICANT_DATA'. [SQLSTATE 01000]
DBCC results for 'WQ_DEFINITION'. [SQLSTATE 01000]
There are 3327 rows in 194 pages for object 'WQ_DEFINITION'. [SQLSTATE 01000]
DBCC results for 'ARCHIVING'. [SQLSTATE 01000]
There are 289 rows in 21 pages for object 'ARCHIVING'. [SQLSTATE 01000]
DBCC results for 'RV_GROUPS'. [SQLSTATE 01000]
There are 462 rows in 9 pages for object 'RV_GROUPS'. [SQLSTATE 01000]
DBCC results for 'SCHEDULE'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'SCHEDULE'. [SQLSTATE 01000]
DBCC results for 'HR_APPLICANT_JOBS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_APPLICANT_JOBS'. [SQLSTATE 01000]
DBCC results for 'Security_Rights'. [SQLSTATE 01000]
There are 90 rows in 3 pages for object 'Security_Rights'. [SQLSTATE 01000]
DBCC results for 'composite_work'. [SQLSTATE 01000]
There are 15042 rows in 449 pages for object 'composite_work'. [SQLSTATE 01000]
DBCC results for 'SERVICE_FILE'. [SQLSTATE 01000]
There are 41 rows in 1 pages for object 'SERVICE_FILE'. [SQLSTATE 01000]
DBCC results for 'HR_APPLICANT_PREVIOUSNAME'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_APPLICANT_PREVIOUSNAME'. [SQLSTATE 01000]
DBCC results for 'adi_outbound'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'adi_outbound'. [SQLSTATE 01000]
DBCC results for 'SETS'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'SETS'. [SQLSTATE 01000]
DBCC results for 'HR_APPLICANT_STATUS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_APPLICANT_STATUS'. [SQLSTATE 01000]
DBCC results for 'WQ_FORMS'. [SQLSTATE 01000]
There are 8 rows in 1 pages for object 'WQ_FORMS'. [SQLSTATE 01000]
DBCC results for 'ASSIGNMENTS_trigger'. [SQLSTATE 01000]
There are 20308842 rows in 399563 pages for object 'ASSIGNMENTS_trigger'. [SQLSTATE 01000]
DBCC results for 'atemp_trans_PhysDefRpt'. [SQLSTATE 01000]
There are 3440 rows in 109 pages for object 'atemp_trans_PhysDefRpt'. [SQLSTATE 01000]
DBCC results for 'UserGroupsModules'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'UserGroupsModules'. [SQLSTATE 01000]
DBCC results for 'WQ_LINKAGE'. [SQLSTATE 01000]
There are 550 rows in 41 pages for object 'WQ_LINKAGE'. [SQLSTATE 01000]
DBCC results for 'HR_APP_JOBS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_APP_JOBS'. [SQLSTATE 01000]
DBCC results for 'WQ_TEMP_ALERTS'. [SQLSTATE 01000]
There are 1 rows in 5 pages for object 'WQ_TEMP_ALERTS'. [SQLSTATE 01000]
DBCC results for 'SIGN_CONTROL'. [SQLSTATE 01000]
There are 355 rows in 11 pages for object 'SIGN_CONTROL'. [SQLSTATE 01000]
DBCC results for 'ASSIGNMENTS'. [SQLSTATE 01000]
There are 30123 rows in 102071 pages for object 'ASSIGNMENTS'. [SQLSTATE 01000]
DBCC results for 'HR_COSTCENTER'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_COSTCENTER'. [SQLSTATE 01000]
DBCC results for 'ROI_Billing_Type'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'ROI_Billing_Type'. [SQLSTATE 01000]
DBCC results for 'WQ_TEMP_DEFINITION'. [SQLSTATE 01000]
There are 3327 rows in 168 pages for object 'WQ_TEMP_DEFINITION'. [SQLSTATE 01000]
DBCC results for 'SIGNATURES'. [SQLSTATE 01000]
There are 6269 rows in 3564 pages for object 'SIGNATURES'. [SQLSTATE 01000]
DBCC results for 'STATUS'. [SQLSTATE 01000]
There are 9 rows in 1 pages for object 'STATUS'. [SQLSTATE 01000]
DBCC results for 'HR_DEPARTMENTS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_DEPARTMENTS'. [SQLSTATE 01000]
DBCC results for 'HR_EEOC'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_EEOC'. [SQLSTATE 01000]
DBCC results for 'ROI_Invoice'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'ROI_Invoice'. [SQLSTATE 01000]
DBCC results for 'WQ_TEMP_LINKAGE'. [SQLSTATE 01000]
There are 550 rows in 39 pages for object 'WQ_TEMP_LINKAGE'. [SQLSTATE 01000]
DBCC results for 'STUDY_DESCRIPTION'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'STUDY_DESCRIPTION'. [SQLSTATE 01000]
DBCC results for 'HR_EMPLOYEE_CLASS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_EMPLOYEE_CLASS'. [SQLSTATE 01000]
DBCC results for 'ROI_Requester'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'ROI_Requester'. [SQLSTATE 01000]
DBCC results for 'WQ_TEMP_USERS'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'WQ_TEMP_USERS'. [SQLSTATE 01000]
DBCC results for 'SUSPENSION_LOG'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'SUSPENSION_LOG'. [SQLSTATE 01000]
DBCC results for 'ROI_Invoice_Payment'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'ROI_Invoice_Payment'. [SQLSTATE 01000]
DBCC results for 'SYSPARMS_GLOBAL'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'SYSPARMS_GLOBAL'. [SQLSTATE 01000]
DBCC results for 'WQ_USERS'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'WQ_USERS'. [SQLSTATE 01000]
DBCC results for 'SYSPARMS'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'SYSPARMS'. [SQLSTATE 01000]
DBCC results for 'HR_EMPLOYEE_DATA'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_EMPLOYEE_DATA'. [SQLSTATE 01000]
DBCC results for 'SYSPARMS_FACILITY'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'SYSPARMS_FACILITY'. [SQLSTATE 01000]
DBCC results for 'ROI_Request'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'ROI_Request'. [SQLSTATE 01000]
DBCC results for 'TRANS_FORMATS'. [SQLSTATE 01000]
There are 8 rows in 1 pages for object 'TRANS_FORMATS'. [SQLSTATE 01000]
DBCC results for 'HR_EMPLOYEE_JOBS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_EMPLOYEE_JOBS'. [SQLSTATE 01000]
DBCC results for 'HR_EMPLOYEE_POSITIONS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_EMPLOYEE_POSITIONS'. [SQLSTATE 01000]
DBCC results for 'User_Facility'. [SQLSTATE 01000]
There are 2696 rows in 23 pages for object 'User_Facility'. [SQLSTATE 01000]
DBCC results for 'ROI_Requester_Type'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'ROI_Requester_Type'. [SQLSTATE 01000]
DBCC results for 'User_Pref'. [SQLSTATE 01000]
There are 29490 rows in 658 pages for object 'User_Pref'. [SQLSTATE 01000]
DBCC results for 'HR_EMPLOYEE_PREVIOUSNAMES'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_EMPLOYEE_PREVIOUSNAMES'. [SQLSTATE 01000]
DBCC results for 'User_Security'. [SQLSTATE 01000]
There are 19805 rows in 116 pages for object 'User_Security'. [SQLSTATE 01000]
DBCC results for 'HR_EMPLOYEE_STATUS'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_EMPLOYEE_STATUS'. [SQLSTATE 01000]
DBCC results for 'USER_STATS'. [SQLSTATE 01000]
There are 30720 rows in 310 pages for object 'USER_STATS'. [SQLSTATE 01000]
DBCC results for 'USERS'. [SQLSTATE 01000]
There are 2697 rows in 193 pages for object 'USERS'. [SQLSTATE 01000]
DBCC results for 'ROI_Request_Release'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'ROI_Request_Release'. [SQLSTATE 01000]
DBCC results for 'WORK_FLOW'. [SQLSTATE 01000]
There are 4798 rows in 470 pages for object 'WORK_FLOW'. [SQLSTATE 01000]
DBCC results for 'AGENT_PARMS'. [SQLSTATE 01000]
There are 109 rows in 6 pages for object 'AGENT_PARMS'. [SQLSTATE 01000]
DBCC results for 'HR_WORKERS_COMP'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'HR_WORKERS_COMP'. [SQLSTATE 01000]
DBCC results for 'CAB_HOLDback'. [SQLSTATE 01000]
There are 43261 rows in 2885 pages for object 'CAB_HOLDback'. [SQLSTATE 01000]
DBCC results for 'DischAdmitEncounters'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'DischAdmitEncounters'. [SQLSTATE 01000]
DBCC results for 'OUTBOUND_EVENT_INDEXES'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object 'OUTBOUND_EVENT_INDEXES'. [SQLSTATE 01000]
DBCC results for 'SEGMENTS'. [SQLSTATE 01000]
There are 157 rows in 2 pages for object 'SEGMENTS'. [SQLSTATE 01000]
DBCC results for 'adi_work'. [SQLSTATE 01000]
There are 0 rows in 4 pages for object 'adi_work'. [SQLSTATE 01000]
DBCC results for 'TRANSACTIONS'. [SQLSTATE 01000]
There are 97 rows in 2 pages for object 'TRANSACTIONS'. [SQLSTATE 01000]
DBCC results for 'dtproperties'. [SQLSTATE 01000]
There are 0 rows in 1 pages for object 'dtproperties'. [SQLSTATE 01000]
DBCC results for 'ACTION_COLUMNS'. [SQLSTATE 01000]
There are 1778 rows in 62 pages for object 'ACTION_COLUMNS'. [SQLSTATE 01000]
CHECKDB found 1 allocation errors and 0 consistency errors in database 'cabinet'. [SQLSTATE 01000]
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (cabinet ). [SQLSTATE 01000]
DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]
April 24, 2008 at 5:39 am
You won't lose any data. This is most likely a single-bit corruption in one of the allocation bitmaps. A GAM page controls whether an extent is available for allocation to any objects - if the GAM says its already in use, but nothing actually is using it, then that indicates a corruption.
You should be fine running REPAIR_ALLOW_DATA_LOSS - and you only need to run DBCC CHECKALLOC with repair - that will be faster and have yo uin SINGLE_USER mode for less time.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 24, 2008 at 6:19 am
Thank you very much, Paul. I appreciate your time.
Jay
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply