Forum Discussion

Bolton_IT's avatar
Bolton_IT
Level 3
10 years ago

V-79-57344-65085 - There was a problem running the DBCC

Hello

 

I have created a new backup job for a server containing an SQL database(s). However I get various instances of the "V-79-57344-65085 - There was a problem running the DBCC." error ,which I believe relates to inconsistency checks; which has caused the job to fail the last 2 nights. I have tried running dbcc manually through SQL on the affected databases and it comes back with 0 errors.

 

I am unsure how to proceed in fixing this job?

 

Job Log for NIMROD.BAL.local Backup 00043-Incremental 


--------------------------------------------------------------------------------


Completed status: Failed    See error(s)  
Expand AllCollapse All  


Job Information 
Job server: BACKUP01
Job name: NIMROD.BAL.local Backup 00043-Incremental
Job started: Tuesday, August 25, 2015 at 7:00:03 PM
Job type: Backup
Job Log: BEX_BACKUP01_06371.xml



Drive and media mount requested: 8/25/2015 7:00:04 PM

Device and Media Information 
Drive and media information from media mount: 8/25/2015 7:00:06 PM
Drive Name: Disk storage 0001
Media Label: B2D004747
Media GUID: {6e080236-bae8-4d59-aa5d-dc3fd557a981}

All Media Used
 B2D004747

 B2D004748

 B2D004749





Job Operation - Backup  
Backup Options 
Media operation - Append to media, overwrite if no appendable media is available.

Compression Type: None

Encryption Type: None





Backup Set Retention Period: 1 Week.
Server - NIMROD.BAL.local 
Note: Resource: "NIMROD.BAL.local\MSSQLSERVER" is not snappable. Attempting to back up directly from the source volume.
Network control connection is established between 10.8.2.8:55707 <--> 10.8.2.4:10000
Network data connection is established between    10.8.2.8:55708 <--> 10.8.2.4:50372

Database Consistency Checks 
Consistency checking AB
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking BoltonStockTake
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking DataTakeOn
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking FIFO_Backup
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking helpdesk
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking NewTraining
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.



Consistency checking ReportServer
Consistency Check Physical Only.
Consistency check was completed.
Consistency checking ReportServerTempDB
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

Consistency checking SiteServices
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure

Consistency checking SO_PO_Restore
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure

Consistency checking StockTakeTest
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure

Consistency checking Test
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure

Consistency checking Training
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure

Consistency checking whd
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure

Consistency checking WinMan
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure

Consistency checking WinManMaster
Consistency Check Physical Only.
V-79-57344-65085 - There was a problem running the DBCC.
Connection failure





Set Information - NIMROD.BAL.local\MSSQLSERVER 
Backup Set Information 
Family Name: "Media created 8/25/2015 7:00:04 PM"
Backup of "NIMROD.BAL.local\MSSQLSERVER"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Backup Method: Log - Back up transaction log
Microsoft SQL Server Agent: Started




Backup started on 8/25/2015 at 9:14:32 PM.
Backup completed on 8/25/2015 at 9:14:33 PM.

Backup Set Summary 
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min




This backup set may not contain any data.




Snapshot Technology: Started for resource: "\\NIMROD.BAL.local\D:". Snapshot technology used: Microsoft Volume Shadow Copy Service (VSS).
The snapshot technology used by VSS for volume D: - Microsoft Software Shadow Copy provider 1.0 (Version 1.0.0.7).

Drive and media mount requested: 8/25/2015 9:14:36 PM

No appendable media could be mounted.
Switching to overwrite operation on scratch media.



Drive and media information from media mount: 8/25/2015 9:14:38 PM
Drive Name: Disk storage 0001
Media Label: B2D004748
Media GUID: {edef265e-3c95-4772-9559-dd7fbe238c70}
 Network control connection is established between 10.8.2.8:55707 <--> 10.8.2.4:10000
Network data connection is established between    10.8.2.8:52905 <--> 10.8.2.4:51004

Set Information - \\NIMROD.BAL.local\D: 
Backup Set Information 
Family Name: "Media created 8/25/2015 7:00:04 PM"
Backup of "\\NIMROD.BAL.local\D:"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Backup Method: Incremental - Using modified time




Backup started on 8/25/2015 at 9:15:04 PM.
Backup completed on 8/25/2015 at 9:15:11 PM.

Backup Set Summary 
Backed up 402 files in 409 directories.
Processed 52,075,082 bytes in  7 seconds.
Throughput rate: 426 MB/min






Snapshot Technology: Started for resource: "\\NIMROD.BAL.local\C:". Snapshot technology used: Microsoft Volume Shadow Copy Service (VSS).
The snapshot technology used by VSS for volume C: - Microsoft Software Shadow Copy provider 1.0 (Version 1.0.0.7).

Drive and media mount requested: 8/25/2015 9:15:13 PM

No appendable media could be mounted.
Switching to overwrite operation on scratch media.



Drive and media information from media mount: 8/25/2015 9:15:16 PM
Drive Name: Disk storage 0001
Media Label: B2D004749
Media GUID: {e224467f-228a-46f7-90eb-2400dca0d5cf}
 Network control connection is established between 10.8.2.8:55707 <--> 10.8.2.4:10000
Network data connection is established between    10.8.2.8:52988 <--> 10.8.2.4:51050

Set Information - \\NIMROD.BAL.local\C: 
Backup Set Information 
Family Name: "Media created 8/25/2015 7:00:04 PM"
Backup of "\\NIMROD.BAL.local\C:"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"
Backup Method: Incremental - Using modified time




Backup started on 8/25/2015 at 9:15:42 PM.
Backup completed on 8/25/2015 at 9:18:09 PM.

Backup Set Summary 
Backed up 1053 files in 205 directories.
Processed 3,857,423,574 bytes in  2 minutes and  27 seconds.
Throughput rate: 1502 MB/min










Job Operation - Verify  

Server - NIMROD.BAL.local 
Drive and media mount requested: 8/25/2015 9:18:11 PM
Drive and media information from media mount: 8/25/2015 9:18:11 PM
Drive Name: Disk storage 0001
Media Label: B2D004747
Media GUID: {6e080236-bae8-4d59-aa5d-dc3fd557a981}

All Media Used
 B2D004747

 B2D004748

 B2D004749

 
Set Information - NIMROD.BAL.local\MSSQLSERVER  
Verify Set Information 
Verify of "NIMROD.BAL.local\MSSQLSERVER "
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"




Verify started on 8/25/2015 at 9:18:11 PM.
Verify completed on 8/25/2015 at 9:18:11 PM.

Verify Set Summary 
Processed 0 bytes in  1 second.
Throughput rate: 0.000 MB/min








Server - NIMROD.BAL.local 
Drive and media mount requested: 8/25/2015 9:18:12 PM
Drive and media information from media mount: 8/25/2015 9:18:12 PM
Drive Name: Disk storage 0001
Media Label: B2D004748
Media GUID: {edef265e-3c95-4772-9559-dd7fbe238c70}
 
Set Information - \\NIMROD.BAL.local\D: Data 
Verify Set Information 
Verify of "\\NIMROD.BAL.local\D: Data"
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"




Verify started on 8/25/2015 at 9:18:12 PM.
Verify completed on 8/25/2015 at 9:18:14 PM.

Verify Set Summary 
Verified 402 files in 409 directories.
Processed 52,075,082 bytes in  2 seconds.
Throughput rate: 1490 MB/min








Server - NIMROD.BAL.local 
Drive and media mount requested: 8/25/2015 9:18:15 PM
Drive and media information from media mount: 8/25/2015 9:18:15 PM
Drive Name: Disk storage 0001
Media Label: B2D004749
Media GUID: {e224467f-228a-46f7-90eb-2400dca0d5cf}
 
Set Information - \\NIMROD.BAL.local\C:  
Verify Set Information 
Verify of "\\NIMROD.BAL.local\C: "
Backup set #1 on storage media #1
Backup set description: "NIMROD.BAL.local Backup 00043-Incremental"




Verify started on 8/25/2015 at 9:18:15 PM.
Verify completed on 8/25/2015 at 9:18:45 PM.

Verify Set Summary 
Verified 1053 files in 205 directories.
Processed 3,857,423,574 bytes in  30 seconds.
Throughput rate: 7357 MB/min










Job Completion Status 
Job ended: Tuesday, August 25, 2015 at 9:18:46 PM
Completed status: Failed
Final error: 0xe0008443 - One or more SQL Database consistency checks have failed.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-33859



Errors 
Click an error below to locate it in the job log
Backup- NIMROD.BAL.localV-79-57344-65085 - There was a problem running the DBCC.

Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

V-79-57344-65085 - There was a problem running the DBCC.

[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure

V-79-57344-65085 - There was a problem running the DBCC.

Connection failure


 

  • The error lines are these:-

    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent.
    Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

    These links may help -

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6548a457-7c46-4012-9892-432be9d391d8/error-message-when-i-do-dbcc-checkdb?forum=sqldatabaseengine

    https://msdn.microsoft.com/en-us/library/aa337354.aspx

     

  • I just checked and no; the BE is using the Windows logon/admin account whereas in SQL I was logging in with the database user instead. So I logged in with the admin account and ran the DBCC on a db again and got this

     

    DBCC results for 'NewTraining'.
    Msg 8921, Level 16, State 1, Line 2
    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
    DBCC results for 'sys.sysrscols'.
    There are 9479 rows in 102 pages for object "sys.sysrscols".
    DBCC results for 'sys.sysrowsets'.
    There are 1204 rows in 24 pages for object "sys.sysrowsets".
    DBCC results for 'sys.sysallocunits'.
    There are 1387 rows in 40 pages for object "sys.sysallocunits".
    DBCC results for 'sys.sysfiles1'.
    There are 2 rows in 1 pages for object "sys.sysfiles1".
    DBCC results for 'sys.syspriorities'.
    There are 0 rows in 0 pages for object "sys.syspriorities".
    DBCC results for 'sys.sysfgfrag'.
    There are 2 rows in 1 pages for object "sys.sysfgfrag".
    DBCC results for 'sys.sysphfg'.
    There are 1 rows in 1 pages for object "sys.sysphfg".
    DBCC results for 'sys.sysprufiles'.
    There are 2 rows in 1 pages for object "sys.sysprufiles".
    DBCC results for 'sys.sysftinds'.
    There are 3 rows in 1 pages for object "sys.sysftinds".
    DBCC results for 'sys.sysowners'.
    There are 16 rows in 1 pages for object "sys.sysowners".
    DBCC results for 'sys.sysprivs'.
    There are 177 rows in 1 pages for object "sys.sysprivs".
    DBCC results for 'sys.sysschobjs'.
    There are 10534 rows in 246 pages for object "sys.sysschobjs".
    DBCC results for 'sys.syscolpars'.
    There are 31172 rows in 818 pages for object "sys.syscolpars".
    DBCC results for 'sys.sysnsobjs'.
    There are 1 rows in 1 pages for object "sys.sysnsobjs".
    DBCC results for 'sys.syscerts'.
    There are 0 rows in 0 pages for object "sys.syscerts".
    DBCC results for 'sys.sysxprops'.
    There are 270 rows in 122 pages for object "sys.sysxprops".
    DBCC results for 'sys.sysscalartypes'.
    There are 34 rows in 1 pages for object "sys.sysscalartypes".
    DBCC results for 'sys.systypedsubobjs'.
    There are 0 rows in 0 pages for object "sys.systypedsubobjs".
    DBCC results for 'sys.sysidxstats'.
    There are 3895 rows in 89 pages for object "sys.sysidxstats".
    DBCC results for 'sys.sysiscols'.
    There are 4812 rows in 32 pages for object "sys.sysiscols".
    DBCC results for 'sys.sysbinobjs'.
    There are 23 rows in 1 pages for object "sys.sysbinobjs".
    DBCC results for 'sys.sysaudacts'.
    There are 0 rows in 0 pages for object "sys.sysaudacts".
    DBCC results for 'sys.sysobjvalues'.
    There are 12781 rows in 4588 pages for object "sys.sysobjvalues".
    DBCC results for 'sys.sysclsobjs'.
    There are 20 rows in 1 pages for object "sys.sysclsobjs".
    DBCC results for 'sys.sysrowsetrefs'.
    There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
    DBCC results for 'sys.sysremsvcbinds'.
    There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
    DBCC results for 'sys.sysxmitqueue'.
    There are 0 rows in 0 pages for object "sys.sysxmitqueue".
    DBCC results for 'sys.sysrts'.
    There are 1 rows in 1 pages for object "sys.sysrts".
    DBCC results for 'sys.sysconvgroup'.
    There are 0 rows in 0 pages for object "sys.sysconvgroup".
    DBCC results for 'sys.sysdesend'.
    There are 0 rows in 0 pages for object "sys.sysdesend".
    DBCC results for 'sys.sysdercv'.
    There are 0 rows in 0 pages for object "sys.sysdercv".
    DBCC results for 'sys.syssingleobjrefs'.
    There are 2344 rows in 19 pages for object "sys.syssingleobjrefs".
    DBCC results for 'sys.sysmultiobjrefs'.
    There are 73072 rows in 746 pages for object "sys.sysmultiobjrefs".
    DBCC results for 'sys.sysguidrefs'.
    There are 2 rows in 1 pages for object "sys.sysguidrefs".
    DBCC results for 'sys.syscompfragments'.
    There are 9 rows in 1 pages for object "sys.syscompfragments".
    DBCC results for 'sys.sysftstops'.
    There are 0 rows in 0 pages for object "sys.sysftstops".
    DBCC results for 'sys.sysqnames'.
    There are 99 rows in 1 pages for object "sys.sysqnames".
    DBCC results for 'sys.sysxmlcomponent'.
    There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
    DBCC results for 'sys.sysxmlfacet'.
    There are 112 rows in 1 pages for object "sys.sysxmlfacet".
    DBCC results for 'sys.sysxmlplacement'.
    There are 18 rows in 1 pages for object "sys.sysxmlplacement".
    DBCC results for 'sys.sysobjkeycrypts'.
    There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
    DBCC results for 'sys.sysasymkeys'.
    There are 0 rows in 0 pages for object "sys.sysasymkeys".
    DBCC results for 'sys.syssqlguides'.
    There are 0 rows in 0 pages for object "sys.syssqlguides".
    DBCC results for 'sys.sysbinsubobjs'.
    There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
    DBCC results for 'sys.syssoftobjrefs'.
    There are 18503 rows in 280 pages for object "sys.syssoftobjrefs".
    DBCC results for 'ProgramTree'.
    There are 207 rows in 6 pages for object "ProgramTree".
    DBCC results for 'FixedAssetTypes'.
    There are 4 rows in 1 pages for object "FixedAssetTypes".
    DBCC results for 'SupportCaseReasons'.
    There are 4 rows in 1 pages for object "SupportCaseReasons".
    DBCC results for 'UserIllnesses'.
    There are 0 rows in 0 pages for object "UserIllnesses".
    DBCC results for 'KanBanPurchaseItems'.
    There are 0 rows in 0 pages for object "KanBanPurchaseItems".
    DBCC results for 'PurchaseOrderItemsHistory'.
    There are 1733 rows in 138 pages for object "PurchaseOrderItemsHistory".
    DBCC results for 'TickleCategories'.
    There are 5 rows in 1 pages for object "TickleCategories".
    DBCC results for 'CommissionGroups'.
    There are 0 rows in 0 pages for object "CommissionGroups".
    DBCC results for 'bdt_FiFoAudit'.
    There are 17324 rows in 327 pages for object "bdt_FiFoAudit".
    DBCC results for 'JobStatuses'.
    There are 0 rows in 0 pages for object "JobStatuses".
    DBCC results for 'CustomFields'.
    There are 92 rows in 5 pages for object "CustomFields".
    DBCC results for 'ProductProductCategories'.
    There are 0 rows in 0 pages for object "ProductProductCategories".
    DBCC results for 'Regions'.
    There are 128 rows in 2 pages for object "Regions".
    DBCC results for 'CRMConversationItems'.
    There are 0 rows in 0 pages for object "CRMConversationItems".
    DBCC results for 'ExpressionRules'.
    There are 0 rows in 0 pages for object "ExpressionRules".
    DBCC results for 'WorkInProgress'.
    There are 141614 rows in 14060 pages for object "WorkInProgress".
    DBCC results for 'GLCategories'.
    There are 8 rows in 1 pages for object "GLCategories".
    DBCC results for 'Reports'.
    There are 14 rows in 1 pages for object "Reports".
    DBCC results for 'Manufacturers'.
    There are 6 rows in 1 pages for object "Manufacturers".
    DBCC results for 'StructureVersions'.
    There are 13671 rows in 264 pages for object "StructureVersions".
    DBCC results for 'Bdt_RawMaterialFIFO'.
    There are 529 rows in 19 pages for object "Bdt_RawMaterialFIFO".
    DBCC results for 'UsersSpeedDials'.
    There are 0 rows in 0 pages for object "UsersSpeedDials".
    DBCC results for 'SalesOrderSources'.
    There are 0 rows in 0 pages for object "SalesOrderSources".
    DBCC results for 'sys.ifts_comp_fragment_1111167204_129'.
    There are 6 rows in 1 pages for object "sys.ifts_comp_fragment_1111167204_129".
    DBCC results for 'ShippingTerms'.
    There are 8 rows in 1 pages for object "ShippingTerms".
    DBCC results for 'SecurityAreaDescriptions'.
    There are 1 rows in 1 pages for object "SecurityAreaDescriptions".
    DBCC results for 'ReturnedItems'.
    There are 0 rows in 0 pages for object "ReturnedItems".
    DBCC results for 'WorkInProgressRequirements'.
    There are 1341 rows in 25 pages for object "WorkInProgressRequirements".
    DBCC results for 'ConfiguredItemStructures'.
    There are 0 rows in 0 pages for object "ConfiguredItemStructures".
    DBCC results for 'JobPrefixDepartments'.
    There are 0 rows in 0 pages for object "JobPrefixDepartments".
    DBCC results for 'sys.ifts_comp_fragment_1111167204_131'.
    There are 6 rows in 1 pages for object "sys.ifts_comp_fragment_1111167204_131".
    DBCC results for 'ConfiguredComponentRules'.
    There are 0 rows in 0 pages for object "ConfiguredComponentRules".
    DBCC results for 'ProductOverheadTypes'.
    There are 0 rows in 0 pages for object "ProductOverheadTypes".
    DBCC results for 'sys.ifts_comp_fragment_1111167204_132'.
    There are 6 rows in 1 pages for object "sys.ifts_comp_fragment_1111167204_132".
    DBCC results for 'SalesOrderItemCommissions'.
    There are 0 rows in 0 pages for object "SalesOrderItemCommissions".
    DBCC results for 'ActivityTracking'.
    There are 0 rows in 0 pages for object "ActivityTracking".
    DBCC results for 'ConfiguredDimensionValues'.
    There are 77770 rows in 2548 pages for object "ConfiguredDimensionValues".
    DBCC results for 'CRMTaskStatuses'.
    There are 2 rows in 1 pages for object "CRMTaskStatuses".
    DBCC results for 'bdt_ChemicalTestResults'.
    There are 37 rows in 2 pages for object "bdt_ChemicalTestResults".
    DBCC results for 'CustomerCommissionAgents'.
    There are 0 rows in 0 pages for object "CustomerCommissionAgents".
    DBCC results for 'SProcProgress'.
    There are 56 rows in 4 pages for object "SProcProgress".
    DBCC results for 'CRMProjectStatuses'.
    There are 1 rows in 1 pages for object "CRMProjectStatuses".
    DBCC results for 'CRMContacts'.
    There are 50 rows in 4 pages for object "CRMContacts".
    DBCC results for 'CellManufacturingOrders'.
    There are 0 rows in 0 pages for object "CellManufacturingOrders".
    DBCC results for 'StockTake'.
    There are 0 rows in 0 pages for object "StockTake".
    DBCC results for 'CRMCompanies'.
    There are 801 rows in 79 pages for object "CRMCompanies".
    DBCC results for 'CRMConversationItemResponses'.
    There are 0 rows in 0 pages for object "CRMConversationItemResponses".
    DBCC results for 'Intrastats'.
    There are 0 rows in 0 pages for object "Intrastats".
    DBCC results for 'Structures'.
    There are 54304 rows in 2605 pages for object "Structures".
    DBCC results for 'bdt_BoltonTargets'.
    There are 1160 rows in 33 pages for object "bdt_BoltonTargets".
    DBCC results for 'sys.ifts_comp_fragment_1563152614_3807'.
    There are 4250 rows in 40 pages for object "sys.ifts_comp_fragment_1563152614_3807".
    DBCC results for 'ConfiguredItemRules'.
    There are 0 rows in 0 pages for object "ConfiguredItemRules".
    DBCC results for 'AccountingCalendar'.
    There are 2192 rows in 29 pages for object "AccountingCalendar".
    DBCC results for 'Styles'.
    There are 2 rows in 1 pages for object "Styles".
    DBCC results for 'bdt_ChemicalTestResultItems'.
    There are 601 rows in 4 pages for object "bdt_ChemicalTestResultItems".
    DBCC results for 'Classifications'.
    There are 135 rows in 4 pages for object "Classifications".
    DBCC results for 'CRMCampaigns'.
    There are 0 rows in 0 pages for object "CRMCampaigns".
    DBCC results for 'CommodityCodes'.
    There are 4 rows in 1 pages for object "CommodityCodes".
    DBCC results for 'ConfiguredItemValues'.
    There are 329301 rows in 10858 pages for object "ConfiguredItemValues".
    DBCC results for 'TaxCodes'.
    There are 2 rows in 1 pages for object "TaxCodes".
    DBCC results for 'ConfiguredSundries'.
    There are 0 rows in 0 pages for object "ConfiguredSundries".
    DBCC results for 'UserPreferences'.
    There are 620 rows in 10 pages for object "UserPreferences".
    DBCC results for 'DeliveryAddresses'.
    There are 1017 rows in 51 pages for object "DeliveryAddresses".
    DBCC results for 'ProductOverheads'.
    There are 0 rows in 0 pages for object "ProductOverheads".
    DBCC results for 'sys.fulltext_index_docidstatus_1563152614'.
    There are 4 rows in 1 pages for object "sys.fulltext_index_docidstatus_1563152614".
    DBCC results for 'CreditTerms'.
    There are 14 rows in 1 pages for object "CreditTerms".
    DBCC results for 'Users'.
    There are 106 rows in 6 pages for object "Users".
    DBCC results for 'TransportRoutes'.
    There are 0 rows in 0 pages for object "TransportRoutes".
    DBCC results for 'CommissionClasses'.
    There are 0 rows in 0 pages for object "CommissionClasses".
    DBCC results for 'sys.fulltext_docidfilter_1563152614'.
    There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1563152614".
    DBCC results for 'Currencies'.
    There are 3 rows in 1 pages for object "Currencies".
    DBCC results for 'TimeSheets'.
    There are 0 rows in 0 pages for object "TimeSheets".
    DBCC results for 'SupplierProductContracts'.
    There are 0 rows in 0 pages for object "SupplierProductContracts".
    DBCC results for 'ProcessTestTypes'.
    There are 0 rows in 0 pages for object "ProcessTestTypes".
    DBCC results for 'WebComSites'.
    There are 0 rows in 0 pages for object "WebComSites".
    DBCC results for 'SiteProducts'.
    There are 0 rows in 0 pages for object "SiteProducts".
    DBCC results for 'sys.fulltext_indexeddocid_1563152614'.
    There are 31957 rows in 72 pages for object "sys.fulltext_indexeddocid_1563152614".
    DBCC results for 'Departments'.
    There are 11 rows in 1 pages for object "Departments".
    DBCC results for 'PerpetualInventory'.
    There are 1 rows in 1 pages for object "PerpetualInventory".
    DBCC results for 'WriteOffCodes'.
    There are 9 rows in 1 pages for object "WriteOffCodes".
    DBCC results for 'TransportAllocations'.
    There are 0 rows in 0 pages for object "TransportAllocations".
    DBCC results for 'sys.fulltext_avdl_1563152614'.
    There are 6 rows in 1 pages for object "sys.fulltext_avdl_1563152614".
    DBCC results for 'Discounts'.
    There are 7 rows in 1 pages for object "Discounts".
    DBCC results for 'GLAccountLogs'.
    There are 11725 rows in 177 pages for object "GLAccountLogs".
    DBCC results for 'WorkSchedules'.
    There are 3 rows in 1 pages for object "WorkSchedules".
    DBCC results for 'ReturnedItemsStatuses'.
    There are 0 rows in 0 pages for object "ReturnedItemsStatuses".
    DBCC results for 'GLAccountDepartments'.
    There are 1 rows in 1 pages for object "GLAccountDepartments".
    DBCC results for 'SupplierCrossReferences'.
    There are 669 rows in 28 pages for object "SupplierCrossReferences".
    DBCC results for 'FreeFormRelations'.
    There are 6 rows in 1 pages for object "FreeFormRelations".
    DBCC results for 'GLAccountDivisions'.
    There are 1 rows in 1 pages for object "GLAccountDivisions".
    DBCC results for 'ZipCodes'.
    There are 42995 rows in 528 pages for object "ZipCodes".
    DBCC results for 'bdt_ManufacturingOrderTestResults'.
    There are 0 rows in 0 pages for object "bdt_ManufacturingOrderTestResults".
    DBCC results for 'MatrixStyles'.
    There are 2 rows in 1 pages for object "MatrixStyles".
    DBCC results for 'CustomMatrixTables'.
    There are 0 rows in 0 pages for object "CustomMatrixTables".
    DBCC results for 'CashItems'.
    There are 11445 rows in 673 pages for object "CashItems".
    DBCC results for 'bdt_Specifications'.
    There are 1286 rows in 37 pages for object "bdt_Specifications".
    DBCC results for 'Industries'.
    There are 1 rows in 1 pages for object "Industries".
    DBCC results for 'TransportAllocationPrintHistory'.
    There are 0 rows in 0 pages for object "TransportAllocationPrintHistory".
    DBCC results for 'Solutions'.
    There are 0 rows in 0 pages for object "Solutions".
    DBCC results for 'ConfiguredConfigurations'.
    There are 6599 rows in 342 pages for object "ConfiguredConfigurations".
    DBCC results for 'CustomTable01'.
    There are 0 rows in 0 pages for object "CustomTable01".
    DBCC results for 'Locations'.
    There are 322 rows in 10 pages for object "Locations".
    DBCC results for 'DiscountBreaks'.
    There are 0 rows in 0 pages for object "DiscountBreaks".
    DBCC results for 'bdt_SpecificationRelations'.
    There are 1212 rows in 24 pages for object "bdt_SpecificationRelations".
    DBCC results for 'JobPrefixes'.
    There are 1 rows in 1 pages for object "JobPrefixes".
    DBCC results for 'Letters'.
    There are 0 rows in 0 pages for object "Letters".
    DBCC results for 'ProgramProfiles'.
    There are 925 rows in 51 pages for object "ProgramProfiles".
    DBCC results for 'FreeFormLinks'.
    There are 99 rows in 2 pages for object "FreeFormLinks".
    DBCC results for 'CommissionSetup'.
    There are 0 rows in 0 pages for object "CommissionSetup".
    DBCC results for 'Countries'.
    There are 246 rows in 6 pages for object "Countries".
    DBCC results for 'PurchaseOrderPrefixes'.
    There are 1 rows in 1 pages for object "PurchaseOrderPrefixes".
    DBCC results for 'Warranties'.
    There are 0 rows in 0 pages for object "Warranties".
    DBCC results for 'WorkScheduleBreaks'.
    There are 0 rows in 0 pages for object "WorkScheduleBreaks".
    DBCC results for 'SecurityProfiles'.
    There are 15 rows in 1 pages for object "SecurityProfiles".
    DBCC results for 'bdt_ChemicalSpecifications'.
    There are 12997 rows in 346 pages for object "bdt_ChemicalSpecifications".
    DBCC results for 'MatrixSizes'.
    There are 9 rows in 1 pages for object "MatrixSizes".
    DBCC results for 'SecurityProfileUsers'.
    There are 108 rows in 3 pages for object "SecurityProfileUsers".
    DBCC results for 'Transports'.
    There are 1 rows in 1 pages for object "Transports".
    DBCC results for 'SettlementTerms'.
    There are 17 rows in 1 pages for object "SettlementTerms".
    DBCC results for 'bdt_PhysicalSpecifications'.
    There are 8698 rows in 213 pages for object "bdt_PhysicalSpecifications".
    DBCC results for 'CustomForms'.
    There are 0 rows in 0 pages for object "CustomForms".
    DBCC results for 'FinancialTargets'.
    There are 0 rows in 0 pages for object "FinancialTargets".
    DBCC results for 'ShipmentsIntegration'.
    There are 0 rows in 0 pages for object "ShipmentsIntegration".
    DBCC results for 'ConfiguredProcesses'.
    There are 0 rows in 0 pages for object "ConfiguredProcesses".
    DBCC results for 'CustomMatrixRows'.
    There are 0 rows in 0 pages for object "CustomMatrixRows".
    DBCC results for 'UnitsOfMeasure'.
    There are 9 rows in 1 pages for object "UnitsOfMeasure".
    DBCC results for 'GeographicalTaxRates'.
    There are 0 rows in 0 pages for object "GeographicalTaxRates".
    DBCC results for 'ShipmentBatches'.
    There are 0 rows in 0 pages for object "ShipmentBatches".
    DBCC results for 'Customers'.
    There are 209 rows in 22 pages for object "Customers".
    DBCC results for 'GLAccountTypes'.
    There are 215 rows in 6 pages for object "GLAccountTypes".
    DBCC results for 'JournalItems'.
    There are 2540 rows in 78 pages for object "JournalItems".
    DBCC results for 'SupportCaseStatuses'.
    There are 4 rows in 1 pages for object "SupportCaseStatuses".
    DBCC results for 'FreeForms'.
    There are 3 rows in 1 pages for object "FreeForms".
    DBCC results for 'sys.ifts_comp_fragment_1563152614_3876'.
    There are 49 rows in 1 pages for object "sys.ifts_comp_fragment_1563152614_3876".
    DBCC results for 'MatrixColours'.
    There are 11 rows in 1 pages for object "MatrixColours".
    DBCC results for 'WorkScheduleCalendar'.
    There are 12 rows in 1 pages for object "WorkScheduleCalendar".
    DBCC results for 'CustomValues'.
    There are 544118 rows in 15284 pages for object "CustomValues".
    DBCC results for 'SalesOrderPrefixes'.
    There are 3 rows in 1 pages for object "SalesOrderPrefixes".
    DBCC results for 'Routes'.
    There are 0 rows in 0 pages for object "Routes".
    DBCC results for 'Budgets'.
    There are 12 rows in 1 pages for object "Budgets".
    DBCC results for 'UsersAccessLogs'.
    There are 19041 rows in 153 pages for object "UsersAccessLogs".
    DBCC results for 'CRMContactTypes'.
    There are 0 rows in 0 pages for object "CRMContactTypes".
    DBCC results for 'ConstantValues'.
    There are 0 rows in 0 pages for object "ConstantValues".
    DBCC results for 'UnitsOfMeasureFactors'.
    There are 17 rows in 1 pages for object "UnitsOfMeasureFactors".
    DBCC results for 'CRMCampaignStatuses'.
    There are 1 rows in 1 pages for object "CRMCampaignStatuses".
    DBCC results for 'SiteUsers'.
    There are 106 rows in 2 pages for object "SiteUsers".
    DBCC results for 'GLChartOfAccounts'.
    There are 189 rows in 7 pages for object "GLChartOfAccounts".
    DBCC results for 'sys.ifts_comp_fragment_1563152614_3880'.
    There are 28 rows in 1 pages for object "sys.ifts_comp_fragment_1563152614_3880".
    DBCC results for 'DistributionLists'.
    There are 0 rows in 0 pages for object "DistributionLists".
    DBCC results for 'ProcessSchedules'.
    There are 0 rows in 0 pages for object "ProcessSchedules".
    DBCC results for 'SalesOrders'.
    There are 5109 rows in 502 pages for object "SalesOrders".
    DBCC results for 'RemoteTransactions'.
    There are 0 rows in 0 pages for object "RemoteTransactions".
    DBCC results for 'IntrastatCNCodes'.
    There are 9443 rows in 413 pages for object "IntrastatCNCodes".
    DBCC results for 'CRMRegions'.
    There are 1 rows in 1 pages for object "CRMRegions".
    DBCC results for 'sys.fulltext_index_docidstatus_1111167204'.
    There are 0 rows in 1 pages for object "sys.fulltext_index_docidstatus_1111167204".
    DBCC results for 'Banks'.
    There are 12 rows in 1 pages for object "Banks".
    DBCC results for 'SalesInvoiceItems'.
    There are 9183 rows in 679 pages for object "SalesInvoiceItems".
    DBCC results for 'Promotions'.
    There are 0 rows in 0 pages for object "Promotions".
    DBCC results for 'bdt_DummyData'.
    There are 6 rows in 2 pages for object "bdt_DummyData".
    DBCC results for 'AuditTables'.
    There are 0 rows in 0 pages for object "AuditTables".
    DBCC results for 'SalesOrderItemAllocations'.
    There are 0 rows in 0 pages for object "SalesOrderItemAllocations".
    DBCC results for 'WarrantyItems'.
    There are 0 rows in 0 pages for object "WarrantyItems".
    DBCC results for 'DistributionListContacts'.
    There are 0 rows in 0 pages for object "DistributionListContacts".
    DBCC results for 'CreditControlLetterItems'.
    There are 0 rows in 0 pages for object "CreditControlLetterItems".
    DBCC results for 'SyncTombStones'.
    There are 1409 rows in 29 pages for object "SyncTombStones".
    DBCC results for 'sys.fulltext_docidfilter_1111167204'.
    There are 123 rows in 1 pages for object "sys.fulltext_docidfilter_1111167204".
    DBCC results for 'bdt_PhysicalTestResults'.
    There are 32 rows in 3 pages for object "bdt_PhysicalTestResults".
    DBCC results for 'Bookmarks'.
    There are 36 rows in 1 pages for object "Bookmarks".
    DBCC results for 'sys.fulltext_indexeddocid_1111167204'.
    There are 51 rows in 1 pages for object "sys.fulltext_indexeddocid_1111167204".
    DBCC results for 'sys.ifts_comp_fragment_1563152614_21'.
    There are 57437 rows in 480 pages for object "sys.ifts_comp_fragment_1563152614_21".
    DBCC results for 'Sundries'.
    There are 56 rows in 3 pages for object "Sundries".
    DBCC results for 'guid'.
    There are 0 rows in 0 pages for object "guid".
    DBCC results for 'Containers'.
    There are 0 rows in 0 pages for object "Containers".
    DBCC results for 'sys.fulltext_avdl_1111167204'.
    There are 3 rows in 1 pages for object "sys.fulltext_avdl_1111167204".
    DBCC results for 'Suppliers'.
    There are 590 rows in 55 pages for object "Suppliers".
    DBCC results for 'ConfiguredItemQuantities'.
    There are 0 rows in 0 pages for object "ConfiguredItemQuantities".
    DBCC results for 'ProgramSecurityTree'.
    There are 230 rows in 4 pages for object "ProgramSecurityTree".
    DBCC results for 'CreditControlLetterStatuses'.
    There are 0 rows in 0 pages for object "CreditControlLetterStatuses".
    DBCC results for 'sys.fulltext_index_docidstatus_1886226070'.
    There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_1886226070".
    DBCC results for 'PurchaseOrders'.
    There are 3208 rows in 157 pages for object "PurchaseOrders".
    DBCC results for 'fft_releaseno'.
    There are 75 rows in 3 pages for object "fft_releaseno".
    DBCC results for 'anchor'.
    There are 0 rows in 0 pages for object "anchor".
    DBCC results for 'sys.fulltext_docidfilter_1886226070'.
    There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1886226070".
    DBCC results for 'CustomMatrixTableValues'.
    There are 0 rows in 0 pages for object "CustomMatrixTableValues".
    DBCC results for 'ProcessControlTemplates'.
    There are 35 rows in 1 pages for object "ProcessControlTemplates".
    DBCC results for 'sys.fulltext_indexeddocid_1886226070'.
    There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_1886226070".
    DBCC results for 'CustomTable10'.
    There are 0 rows in 0 pages for object "CustomTable10".
    DBCC results for 'CommissionAgents'.
    There are 0 rows in 0 pages for object "CommissionAgents".
    DBCC results for 'ProcessAlternatives'.
    There are 0 rows in 0 pages for object "ProcessAlternatives".
    DBCC results for 'Sites'.
    There are 1 rows in 1 pages for object "Sites".
    DBCC results for 'sys.fulltext_avdl_1886226070'.
    There are 1 rows in 1 pages for object "sys.fulltext_avdl_1886226070".
    DBCC results for 'ConfiguredComponents'.
    There are 0 rows in 0 pages for object "ConfiguredComponents".
    DBCC results for 'PurchaseInvoiceItems'.
    There are 15672 rows in 869 pages for object "PurchaseInvoiceItems".
    DBCC results for 'ConfiguredProcessRules'.
    There are 0 rows in 0 pages for object "ConfiguredProcessRules".
    DBCC results for 'PromotionItems'.
    There are 0 rows in 0 pages for object "PromotionItems".
    DBCC results for 'ProductExtendedCosts'.
    There are 9809 rows in 580 pages for object "ProductExtendedCosts".
    DBCC results for 'SalesOrderItemQuantityPrices'.
    There are 0 rows in 0 pages for object "SalesOrderItemQuantityPrices".
    DBCC results for 'CreditControlLetters'.
    There are 2 rows in 1 pages for object "CreditControlLetters".
    DBCC results for 'CRMGroups'.
    There are 1 rows in 1 pages for object "CRMGroups".
    DBCC results for 'InventoryRequirement'.
    There are 32297 rows in 782 pages for object "InventoryRequirement".
    DBCC results for 'Widgets'.
    There are 146 rows in 22 pages for object "Widgets".
    DBCC results for 'SupportCaseCategories'.
    There are 3 rows in 1 pages for object "SupportCaseCategories".
    DBCC results for 'CustomTable04'.
    There are 0 rows in 0 pages for object "CustomTable04".
    DBCC results for 'ConfiguredRelations'.
    There are 0 rows in 0 pages for object "ConfiguredRelations".
    DBCC results for 'CashTemplates'.
    There are 0 rows in 0 pages for object "CashTemplates".
    DBCC results for 'sys.queue_messages_889314478'.
    There are 0 rows in 0 pages for object "sys.queue_messages_889314478".
    DBCC results for 'CRMProjectLeadTypes'.
    There are 4 rows in 1 pages for object "CRMProjectLeadTypes".
    DBCC results for 'Tools'.
    There are 0 rows in 0 pages for object "Tools".
    DBCC results for 'Transfers'.
    There are 0 rows in 0 pages for object "Transfers".
    DBCC results for 'CustomMatrixColumns'.
    There are 0 rows in 0 pages for object "CustomMatrixColumns".
    DBCC results for 'sys.queue_messages_921314592'.
    There are 0 rows in 0 pages for object "sys.queue_messages_921314592".
    DBCC results for 'ActivityCentresProducts'.
    There are 0 rows in 0 pages for object "ActivityCentresProducts".
    DBCC results for 'NumberWords'.
    There are 29 rows in 1 pages for object "NumberWords".
    DBCC results for 'GLClassifications'.
    There are 16 rows in 1 pages for object "GLClassifications".
    DBCC results for 'CustomerCrossReferencePriceBreaks'.
    There are 0 rows in 0 pages for object "CustomerCrossReferencePriceBreaks".
    DBCC results for 'CRMProjectPrefixes'.
    There are 4 rows in 1 pages for object "CRMProjectPrefixes".
    DBCC results for 'CRMConversations'.
    There are 0 rows in 0 pages for object "CRMConversations".
    DBCC results for 'sys.queue_messages_953314706'.
    There are 0 rows in 0 pages for object "sys.queue_messages_953314706".
    DBCC results for 'DBColumnTypes'.
    There are 9 rows in 1 pages for object "DBColumnTypes".
    DBCC results for 'PaymentRuns'.
    There are 70 rows in 2 pages for object "PaymentRuns".
    DBCC results for 'SupplierCrossReferenceManufacturers'.
    There are 0 rows in 0 pages for object "SupplierCrossReferenceManufacturers".
    DBCC results for 'CRMSources'.
    There are 1 rows in 1 pages for object "CRMSources".
    DBCC results for 'SupportCaseSolutions'.
    There are 0 rows in 0 pages for object "SupportCaseSolutions".
    DBCC results for 'ProductTestTypes'.
    There are 0 rows in 0 pages for object "ProductTestTypes".
    DBCC results for 'sys.ifts_comp_fragment_1563152614_3853'.
    There are 128 rows in 1 pages for object "sys.ifts_comp_fragment_1563152614_3853".
    DBCC results for 'CustomFormItems'.
    There are 0 rows in 0 pages for object "CustomFormItems".
    DBCC results for 'zzz_ResourceLabels'.
    There are 0 rows in 0 pages for object "zzz_ResourceLabels".
    DBCC results for 'ExtendedTaxations'.
    There are 0 rows in 0 pages for object "ExtendedTaxations".
    DBCC results for 'CRMProjectQuestions'.
    There are 0 rows in 0 pages for object "CRMProjectQuestions".
    DBCC results for 'SQLQueries'.
    There are 73 rows in 12 pages for object "SQLQueries".
    DBCC results for 'ShipmentBoxes'.
    There are 1 rows in 1 pages for object "ShipmentBoxes".
    DBCC results for 'bdt_ChemicalTestResults_OLD'.
    There are 16 rows in 1 pages for object "bdt_ChemicalTestResults_OLD".
    DBCC results for 'PurchaseOrdersHistory'.
    There are 53 rows in 6 pages for object "PurchaseOrdersHistory".
    DBCC results for 'LocationPutAwayLocations'.
    There are 0 rows in 0 pages for object "LocationPutAwayLocations".
    DBCC results for 'Countries_Tombstone'.
    There are 1 rows in 1 pages for object "Countries_Tombstone".
    DBCC results for 'CRMCalendar'.
    There are 0 rows in 0 pages for object "CRMCalendar".
    DBCC results for 'FreeFormFields'.
    There are 7 rows in 1 pages for object "FreeFormFields".
    DBCC results for 'CRMActions'.
    There are 51 rows in 2 pages for object "CRMActions".
    DBCC results for 'WidgetLayouts'.
    There are 146 rows in 53 pages for object "WidgetLayouts".
    DBCC results for 'IndirectJobs'.
    There are 0 rows in 0 pages for object "IndirectJobs".
    DBCC results for 'ProgramControls'.
    There are 39 rows in 2 pages for object "ProgramControls".
    DBCC results for 'CustomTable03'.
    There are 0 rows in 0 pages for object "CustomTable03".
    DBCC results for 'ProductsHistory'.
    There are 79619 rows in 8535 pages for object "ProductsHistory".
    DBCC results for 'LocationPutAwayMovementSuggestions'.
    There are 0 rows in 0 pages for object "LocationPutAwayMovementSuggestions".
    DBCC results for 'Comments'.
    There are 0 rows in 0 pages for object "Comments".
    DBCC results for 'bdt_ManufacturingOrdersScrap'.
    There are 433 rows in 9 pages for object "bdt_ManufacturingOrdersScrap".
    DBCC results for 'ActionNotifications'.
    There are 0 rows in 0 pages for object "ActionNotifications".
    DBCC results for 'UsersMRUs'.
    There are 2175 rows in 72 pages for object "UsersMRUs".
    DBCC results for 'ShipmentBoxesToInventory'.
    There are 11761 rows in 246 pages for object "ShipmentBoxesToInventory".
    DBCC results for 'Feeds'.
    There are 0 rows in 0 pages for object "Feeds".
    DBCC results for 'ProductStatuses'.
    There are 0 rows in 0 pages for object "ProductStatuses".
    DBCC results for 'SupplierCrossReferencePriceBreaks'.
    There are 0 rows in 0 pages for object "SupplierCrossReferencePriceBreaks".
    DBCC results for 'FixedAssets'.
    There are 835 rows in 31 pages for object "FixedAssets".
    DBCC results for 'SalesInvoices'.
    There are 6325 rows in 421 pages for object "SalesInvoices".
    DBCC results for 'DocumentTypes'.
    There are 1 rows in 1 pages for object "DocumentTypes".
    DBCC results for 'ManufacturingOrderPrefixes'.
    There are 2 rows in 1 pages for object "ManufacturingOrderPrefixes".
    DBCC results for 'Jobs'.
    There are 0 rows in 0 pages for object "Jobs".
    DBCC results for 'CustomTable07'.
    There are 0 rows in 0 pages for object "CustomTable07".
    DBCC results for 'CRMActivities'.
    There are 0 rows in 0 pages for object "CRMActivities".
    DBCC results for 'ActivityCentres'.
    There are 59 rows in 3 pages for object "ActivityCentres".
    DBCC results for 'LabourTransactions'.
    There are 25195 rows in 1571 pages for object "LabourTransactions".
    DBCC results for 'HireOrders'.
    There are 0 rows in 0 pages for object "HireOrders".
    DBCC results for 'AlternativeParts'.
    There are 0 rows in 0 pages for object "AlternativeParts".
    DBCC results for 'bdt_Tests'.
    There are 44 rows in 1 pages for object "bdt_Tests".
    DBCC results for 'SupportCasesInbox'.
    There are 0 rows in 0 pages for object "SupportCasesInbox".
    DBCC results for 'CreditCards'.
    There are 0 rows in 0 pages for object "CreditCards".
    DBCC results for 'AbsenceTypesDetails'.
    There are 0 rows in 0 pages for object "AbsenceTypesDetails".
    DBCC results for 'LocationZones'.
    There are 0 rows in 0 pages for object "LocationZones".
    DBCC results for 'Areas'.
    There are 4 rows in 1 pages for object "Areas".
    DBCC results for 'TransferPendingItems'.
    There are 0 rows in 0 pages for object "TransferPendingItems".
    DBCC results for 'ProductWarranties'.
    There are 0 rows in 0 pages for object "ProductWarranties".
    DBCC results for 'CRMProjectCategories'.
    There are 0 rows in 0 pages for object "CRMProjectCategories".
    DBCC results for 'ToolInstances'.
    There are 0 rows in 0 pages for object "ToolInstances".
    DBCC results for 'AttachedMessages'.
    There are 1 rows in 1 pages for object "AttachedMessages".
    DBCC results for 'bdt_Treatments'.
    There are 35 rows in 1 pages for object "bdt_Treatments".
    DBCC results for 'sys.filestream_tombstone_1312476200'.
    There are 0 rows in 0 pages for object "sys.filestream_tombstone_1312476200".
    DBCC results for 'zzz_MissingColumnCaptions'.
    There are 0 rows in 0 pages for object "zzz_MissingColumnCaptions".
    DBCC results for 'Audit'.
    There are 928379 rows in 19317 pages for object "Audit".
    DBCC results for 'PurchaseInvoices'.
    There are 7835 rows in 448 pages for object "PurchaseInvoices".
    DBCC results for 'sys.syscommittab'.
    There are 0 rows in 0 pages for object "sys.syscommittab".
    DBCC results for 'CustomerShippingMethods'.
    There are 0 rows in 0 pages for object "CustomerShippingMethods".
    DBCC results for 'TransferItems'.
    There are 0 rows in 0 pages for object "TransferItems".
    DBCC results for 'BespokeLabels'.
    There are 5 rows in 1 pages for object "BespokeLabels".
    DBCC results for 'MultiLanguages'.
    There are 0 rows in 0 pages for object "MultiLanguages".
    DBCC results for 'GLReportTotals'.
    There are 10 rows in 1 pages for object "GLReportTotals".
    DBCC results for 'Libraries'.
    There are 2 rows in 1 pages for object "Libraries".
    DBCC results for 'Cash'.
    There are 4082 rows in 205 pages for object "Cash".
    DBCC results for 'PostCodePrimers'.
    There are 0 rows in 0 pages for object "PostCodePrimers".
    DBCC results for 'CustomTable02'.
    There are 0 rows in 0 pages for object "CustomTable02".
    DBCC results for 'ContainerTypes'.
    There are 1 rows in 1 pages for object "ContainerTypes".
    DBCC results for 'TaxReturns'.
    There are 3 rows in 1 pages for object "TaxReturns".
    DBCC results for 'CustomTable09'.
    There are 0 rows in 0 pages for object "CustomTable09".
    DBCC results for 'fft_shiplabel'.
    There are 0 rows in 0 pages for object "fft_shiplabel".
    DBCC results for 'CalendarSources'.
    There are 0 rows in 0 pages for object "CalendarSources".
    DBCC results for 'Counters'.
    There are 23 rows in 1 pages for object "Counters".
    DBCC results for 'LocationStorageTypes'.
    There are 0 rows in 0 pages for object "LocationStorageTypes".
    DBCC results for 'fft_reject'.
    There are 24 rows in 1 pages for object "fft_reject".
    DBCC results for 'CreditReasonCodes'.
    There are 10 rows in 1 pages for object "CreditReasonCodes".
    DBCC results for 'MobileLayouts'.
    There are 0 rows in 0 pages for object "MobileLayouts".
    DBCC results for 'Markups'.
    There are 0 rows in 0 pages for object "Markups".
    DBCC results for 'IndirectJobsDetails'.
    There are 0 rows in 0 pages for object "IndirectJobsDetails".
    DBCC results for 'ToolInstanceItems'.
    There are 0 rows in 0 pages for object "ToolInstanceItems".
    DBCC results for 'HireOrderItems'.
    There are 0 rows in 0 pages for object "HireOrderItems".
    DBCC results for 'ReturnNotes'.
    There are 0 rows in 0 pages for object "ReturnNotes".
    DBCC results for 'ShipmentSchedules'.
    There are 0 rows in 0 pages for object "ShipmentSchedules".
    DBCC results for 'Labels'.
    There are 0 rows in 0 pages for object "Labels".
    DBCC results for 'CustomerCrossReferences'.
    There are 0 rows in 0 pages for object "CustomerCrossReferences".
    DBCC results for 'FixedAssetItems'.
    There are 2835 rows in 57 pages for object "FixedAssetItems".
    DBCC results for 'GLItems'.
    There are 171344 rows in 5392 pages for object "GLItems".
    DBCC results for 'DemandForecasts'.
    There are 1 rows in 1 pages for object "DemandForecasts".
    DBCC results for 'bdt_FinalDimensions'.
    There are 1136 rows in 26 pages for object "bdt_FinalDimensions".
    DBCC results for 'ActivityCentresRelations'.
    There are 0 rows in 0 pages for object "ActivityCentresRelations".
    DBCC results for 'Inventory'.
    There are 135522 rows in 17680 pages for object "Inventory".
    CHECKDB found 0 allocation errors and 0 consistency errors in database 'NewTraining'.
    Msg 802, Level 17, State 20, Line 2
    Error: 802, Severity: 17, State: 20. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
    

     

  • Click on my user name and you can either send me a private message or an email.

    A quick query. Was the manual DBCC run using the same account as that of BE ?

  • Running manual dbcc checks within SQL return 0 errors.

     

    As for logs, I found several errors relating to the incident, many of them relating to memory, but I'm not sure if this is a red herring.

    How do I share event logs with you?

     

     

  • On the SQL server.

    Additionally, does the DBCC checks within SQL itself complete successfully ?

  • Yes it does complete successfully if I turn consistency check off.

     

    As for event logs should I be looking on the backup server or the SQL server?

  • Are there any events logged in the event viewer corresponding to this error ?

    [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
    

    Does the backup itself complete successfully without the consistency checks ?

     

  • Thanks for the replies and apologies in the slow response from me but I had to wait for some down time at work in order to try your suggestions.

     

    I can confirm that both TCP/IP and Named Pipes protocols are already enabled on the SQL server.

    I have now tried disabling the Advanced Open File options on the backup job but it still failed due to consistency checks. Something I don't understand about that is the fact that I have the box ticked for "continue job even if consistency checks fail".

     

     

  • On the SQL server, enable TCP/IP and Named Pipes protocols. Restart the SQL instances and recheck.

  • Disable Advanced Open File Option if you're using it and run the backup again!

    Thanks!​