DBCC Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

DBCC Error

Author

Topic

chasmx
Starting Member

3 Posts

Posted - 2008-12-10 : 01:26:34

I just upgraded one of our production databases from SQL 2000 to 2005. Now I'm getting an unspecified error when Backup Exec runs DBCC against the database. What should I do to isolate the problem?

Thanks Charles

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-10 : 01:37:00

Run the DBCC command in a query window and post the results here.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

chasmx
Starting Member

3 Posts

Posted - 2008-12-10 : 01:48:13

Does the database need to be in single user mode?

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-10 : 02:26:36

What DBCC command is backup exec trying to run?

--
Gail Shaw
SQL Server MVP

chasmx
Starting Member

3 Posts

Posted - 2008-12-10 : 11:10:07

Here are the results of DBCC CHECKDB:

DBCC results for 'MRTS'.
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.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1239 rows in 11 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 234 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 252 rows in 4 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1239 rows in 11 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 234 rows in 2 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 252 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 20 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 483 rows in 4 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 219 rows in 5 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 980 rows in 14 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 273 rows in 2 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 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 569 rows in 10 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 667 rows in 4 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.sysobjvalues'.
There are 666 rows in 156 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 140 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 341 rows in 2 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 92 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 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 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'EML_EmployeeLog'.
There are 0 rows in 0 pages for object "EML_EmployeeLog".
DBCC results for 'EMLD_EmployeeLogDetail'.
There are 0 rows in 0 pages for object "EMLD_EmployeeLogDetail".
DBCC results for 'BP_BoilerPlate'.
There are 212 rows in 13 pages for object "BP_BoilerPlate".
DBCC results for 'CB_CustomerBilling'.
There are 24156 rows in 475 pages for object "CB_CustomerBilling".
DBCC results for 'CDN_CustomerDictatorNumber'.
There are 896 rows in 22 pages for object "CDN_CustomerDictatorNumber".
DBCC results for 'CS_Customer'.
There are 10 rows in 2 pages for object "CS_Customer".
DBCC results for 'CUS_CustomerStatus'.
There are 4 rows in 1 pages for object "CUS_CustomerStatus".
DBCC results for 'CUT_CustomerType'.
There are 4 rows in 1 pages for object "CUT_CustomerType".
DBCC results for 'DC_Dictator'.
There are 924 rows in 38 pages for object "DC_Dictator".
DBCC results for 'DS_DictatorStanding'.
There are 5 rows in 1 pages for object "DS_DictatorStanding".
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object "dtproperties".
DBCC results for 'EM_Employee'.
There are 11 rows in 2 pages for object "EM_Employee".
DBCC results for 'EMH_EmployeeHours'.
There are 30692 rows in 905 pages for object "EMH_EmployeeHours".
DBCC results for 'EMT_EmployeeType'.
There are 4 rows in 1 pages for object "EMT_EmployeeType".
DBCC results for 'EPPV_EmployeePayPlanVersion'.
There are 5 rows in 2 pages for object "EPPV_EmployeePayPlanVersion".
DBCC results for 'FF_FormFields'.
Msg 2508, Level 16, State 3, Line 2
The In-row data RSVD page count for object "FF_FormFields", index ID 0, partition ID 28677019860992, alloc unit ID 28677019860992 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
There are 1597 rows in 32 pages for object "FF_FormFields".
CHECKDB found 0 allocation errors and 1 consistency errors in table 'FF_FormFields' (object ID 437576597).
DBCC results for 'FM_Form'.
There are 47 rows in 5 pages for object "FM_Form".
DBCC results for 'FMV_FormVersion'.
There are 114 rows in 8 pages for object "FMV_FormVersion".
DBCC results for 'FT_FormTemplate'.
There are 24 rows in 2 pages for object "FT_FormTemplate".
DBCC results for 'FTF_FormTemplateFields'.
There are 0 rows in 1 pages for object "FTF_FormTemplateFields".
DBCC results for 'IN_Invoice'.
There are 304 rows in 34 pages for object "IN_Invoice".
DBCC results for 'INN_InvoiceNumber'.
There are 1 rows in 1 pages for object "INN_InvoiceNumber".
DBCC results for 'MDE_Mode'.
There are 2 rows in 1 pages for object "MDE_Mode".
DBCC results for 'PF_NamePrefix'.
There are 5 rows in 1 pages for object "PF_NamePrefix".
DBCC results for 'PL_PackingList'.
There are 311 rows in 40 pages for object "PL_PackingList".
DBCC results for 'PR_Practice'.
There are 11 rows in 2 pages for object "PR_Practice".
DBCC results for 'PRL_Payroll'.
There are 37 rows in 4 pages for object "PRL_Payroll".
DBCC results for 'PRM_ProoferMarkUp'.
There are 10 rows in 1 pages for object "PRM_ProoferMarkUp".
DBCC results for 'PT_Patient'.
There are 15637 rows in 1566 pages for object "PT_Patient".
DBCC results for 'RFF_ReportFormFields'.
There are 313747 rows in 9674 pages for object "RFF_ReportFormFields".
DBCC results for 'RI_ReportInfo'.
There are 24124 rows in 7861 pages for object "RI_ReportInfo".
DBCC results for 'RS_ResultSet'.
There are 0 rows in 1 pages for object "RS_ResultSet".
DBCC results for 'RSC_ResultSetCategory'.
There are 9 rows in 1 pages for object "RSC_ResultSetCategory".
DBCC results for 'RSD_ResultSetDetails'.
There are 0 rows in 1 pages for object "RSD_ResultSetDetails".
DBCC results for 'SE_Session'.
There are 1 rows in 1 pages for object "SE_Session".
DBCC results for 'SF_NameSuffix'.
There are 13 rows in 1 pages for object "SF_NameSuffix".
DBCC results for 'SH_Shorthand'.
There are 7556 rows in 388 pages for object "SH_Shorthand".
DBCC results for 'SP_SystemParameters'.
There are 1 rows in 1 pages for object "SP_SystemParameters".
DBCC results for 'ST_State'.
There are 20 rows in 1 pages for object "ST_State".
DBCC results for 'SX_Sex'.
There are 2 rows in 1 pages for object "SX_Sex".
DBCC results for 'TR_Transmittal'.
There are 3934 rows in 63 pages for object "TR_Transmittal".
DBCC results for 'TRD_TransmittalDetail'.
There are 24139 rows in 491 pages for object "TRD_TransmittalDetail".
DBCC results for 'OLDPATIENTS2004'.
There are 55105 rows in 296 pages for object "OLDPATIENTS2004".
DBCC results for 'OLDDICTATORS2004'.
There are 108 rows in 1 pages for object "OLDDICTATORS2004".
DBCC results for 'sys.queue_messages_1236199454'.
There are 0 rows in 0 pages for object "sys.queue_messages_1236199454".
DBCC results for 'sys.queue_messages_1268199568'.
There are 0 rows in 0 pages for object "sys.queue_messages_1268199568".
DBCC results for 'sys.queue_messages_1300199682'.
There are 0 rows in 0 pages for object "sys.queue_messages_1300199682".
DBCC results for 'TempPatientReportInfoDups'.
There are 24052 rows in 131 pages for object "TempPatientReportInfoDups".
CHECKDB found 0 allocation errors and 1 consistency errors in database 'MRTS'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

It is the "MRTS" database we are have trouble with

Thanks

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2008-12-10 : 11:13:37

Run DBCC UPDATEUSAGE in the database, then run DBCC CHECKDB in the database, and post the new results.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-10 : 11:18:00

It's not a major problem. In SQL 2000, the space used and space available metadata could become incorrect. Hence CheckDB didn't check for it. In 2005 that problem has been fixed and now checkDB does pick that up.

As the checkDB output said, run updateusage.

This is fairly common on databases upgraded from 2000 to 2005. It shouldn't happen again on SQL 2005.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources