February 15, 2013 at 11:48 am
If the repair ran and completed, then the corruption's gone. If you have more problems, some detailed descriptions would be useful.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 16, 2013 at 1:00 am
running "DBCC CHECKDB('msdb', REPAIR_REBUILD) GO"
have below result and again on saving maitenace plan give error :
class not registerd .
would you please let me know as previous asked ,installing SP3.0 resolve this message error ?
--------------------
DBCC results for 'msdb'.
Service Broker Msg 9675, State 1: Message Types analyzed: 16.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 7.
Service Broker Msg 9667, State 1: Services analyzed: 5.
Service Broker Msg 9668, State 1: Service Queues analyzed: 5.
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 1444 rows in 12 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 209 rows in 3 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 243 rows in 3 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 1444 rows in 12 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 209 rows in 3 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 243 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 22 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 290 rows in 3 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 622 rows in 12 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2722 rows in 54 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 2 rows in 1 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 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 334 rows in 6 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 488 rows in 5 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 28 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 751 rows in 193 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 22 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 273 rows in 2 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 2413 rows in 15 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 91 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 618 rows in 23 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 'syssubsystems'.
There are 11 rows in 1 pages for object "syssubsystems".
DBCC results for 'sysproxysubsystem'.
There are 0 rows in 0 pages for object "sysproxysubsystem".
DBCC results for 'restorefilegroup'.
There are 1 rows in 1 pages for object "restorefilegroup".
DBCC results for 'sysproxylogin'.
There are 0 rows in 0 pages for object "sysproxylogin".
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object "logmarkhistory".
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object "sqlagent_info".
DBCC results for 'suspect_pages'.
There are 5 rows in 1 pages for object "suspect_pages".
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object "sysdownloadlist".
DBCC results for 'sysjobhistory'.
There are 108 rows in 18 pages for object "sysjobhistory".
DBCC results for 'log_shipping_primary_databases'.
There are 0 rows in 0 pages for object "log_shipping_primary_databases".
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object "sysdtscategories".
DBCC results for 'sysoriginatingservers'.
There are 0 rows in 0 pages for object "sysoriginatingservers".
DBCC results for 'log_shipping_primary_secondaries'.
There are 0 rows in 0 pages for object "log_shipping_primary_secondaries".
DBCC results for 'sysdtspackages'.
There are 0 rows in 0 pages for object "sysdtspackages".
DBCC results for 'log_shipping_monitor_primary'.
There are 0 rows in 0 pages for object "log_shipping_monitor_primary".
DBCC results for 'log_shipping_monitor_history_detail'.
There are 0 rows in 0 pages for object "log_shipping_monitor_history_detail".
DBCC results for 'log_shipping_monitor_error_detail'.
There are 0 rows in 0 pages for object "log_shipping_monitor_error_detail".
DBCC results for 'log_shipping_secondary'.
There are 0 rows in 0 pages for object "log_shipping_secondary".
DBCC results for 'sysjobs'.
There are 4 rows in 1 pages for object "sysjobs".
DBCC results for 'log_shipping_secondary_databases'.
There are 0 rows in 0 pages for object "log_shipping_secondary_databases".
DBCC results for 'sysjobservers'.
There are 4 rows in 1 pages for object "sysjobservers".
DBCC results for 'log_shipping_monitor_secondary'.
There are 0 rows in 0 pages for object "log_shipping_monitor_secondary".
DBCC results for 'syssessions'.
There are 133 rows in 1 pages for object "syssessions".
DBCC results for 'log_shipping_monitor_alert'.
There are 0 rows in 0 pages for object "log_shipping_monitor_alert".
DBCC results for 'sysjobactivity'.
There are 155 rows in 4 pages for object "sysjobactivity".
DBCC results for 'sysjobsteps'.
There are 4 rows in 1 pages for object "sysjobsteps".
DBCC results for 'sysjobstepslogs'.
There are 0 rows in 0 pages for object "sysjobstepslogs".
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object "sysdtspackagelog".
DBCC results for 'sysdtssteplog'.
There are 0 rows in 0 pages for object "sysdtssteplog".
DBCC results for 'sysschedules'.
There are 2 rows in 1 pages for object "sysschedules".
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object "sysdtstasklog".
DBCC results for 'sysjobschedules'.
There are 2 rows in 1 pages for object "sysjobschedules".
DBCC results for 'syscategories'.
There are 21 rows in 1 pages for object "syscategories".
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object "systargetservers".
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object "systargetservergroups".
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object "systargetservergroupmembers".
DBCC results for 'sysalerts'.
There are 0 rows in 0 pages for object "sysalerts".
DBCC results for 'sysmail_profile'.
There are 0 rows in 0 pages for object "sysmail_profile".
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object "sysoperators".
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object "sysnotifications".
DBCC results for 'sysmaintplan_subplans'.
There are 4 rows in 1 pages for object "sysmaintplan_subplans".
DBCC results for 'sys.queue_messages_843150049'.
There are 0 rows in 0 pages for object "sys.queue_messages_843150049".
DBCC results for 'sysmail_principalprofile'.
There are 0 rows in 0 pages for object "sysmail_principalprofile".
DBCC results for 'sys.queue_messages_875150163'.
There are 0 rows in 0 pages for object "sys.queue_messages_875150163".
DBCC results for 'sysmaintplan_log'.
There are 0 rows in 0 pages for object "sysmaintplan_log".
DBCC results for 'sysmaintplan_logdetail'.
There are 47 rows in 47 pages for object "sysmaintplan_logdetail".
DBCC results for 'sysmail_account'.
There are 0 rows in 0 pages for object "sysmail_account".
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object "systaskids".
DBCC results for 'syscachedcredentials'.
There are 1 rows in 1 pages for object "syscachedcredentials".
DBCC results for 'sysdbmaintplans'.
There are 1 rows in 1 pages for object "sysdbmaintplans".
DBCC results for 'sysmail_profileaccount'.
There are 0 rows in 0 pages for object "sysmail_profileaccount".
DBCC results for 'MSdbms'.
There are 7 rows in 1 pages for object "MSdbms".
DBCC results for 'MSdbms_datatype'.
There are 141 rows in 1 pages for object "MSdbms_datatype".
DBCC results for 'sysmail_servertype'.
There are 1 rows in 1 pages for object "sysmail_servertype".
DBCC results for 'sysdbmaintplan_jobs'.
There are 0 rows in 0 pages for object "sysdbmaintplan_jobs".
DBCC results for 'MSdbms_map'.
There are 248 rows in 3 pages for object "MSdbms_map".
DBCC results for 'sysdbmaintplan_databases'.
There are 0 rows in 0 pages for object "sysdbmaintplan_databases".
DBCC results for 'sysmail_server'.
There are 0 rows in 0 pages for object "sysmail_server".
DBCC results for 'sysdbmaintplan_history'.
There are 0 rows in 0 pages for object "sysdbmaintplan_history".
DBCC results for 'MSdbms_datatype_mapping'.
There are 325 rows in 3 pages for object "MSdbms_datatype_mapping".
DBCC results for 'sysmail_configuration'.
There are 7 rows in 1 pages for object "sysmail_configuration".
DBCC results for 'sysmail_mailitems'.
There are 0 rows in 0 pages for object "sysmail_mailitems".
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object "log_shipping_primaries".
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object "log_shipping_secondaries".
DBCC results for 'sysmail_attachments'.
There are 0 rows in 0 pages for object "sysmail_attachments".
DBCC results for 'sysmail_send_retries'.
There are 0 rows in 0 pages for object "sysmail_send_retries".
DBCC results for 'backupmediaset'.
There are 2117 rows in 27 pages for object "backupmediaset".
DBCC results for 'sysmail_log'.
There are 0 rows in 0 pages for object "sysmail_log".
DBCC results for 'backupmediafamily'.
There are 2117 rows in 50 pages for object "backupmediafamily".
DBCC results for 'sysdtspackages90'.
There are 3 rows in 1 pages for object "sysdtspackages90".
DBCC results for 'backupset'.
There are 2117 rows in 123 pages for object "backupset".
DBCC results for 'sysdtspackagefolders90'.
There are 2 rows in 1 pages for object "sysdtspackagefolders90".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sysmail_query_transfer'.
There are 0 rows in 0 pages for object "sysmail_query_transfer".
DBCC results for 'backupfilegroup'.
There are 2117 rows in 31 pages for object "backupfilegroup".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sysdtslog90'.
There are 0 rows in 0 pages for object "sysdtslog90".
DBCC results for 'sysmail_attachments_transfer'.
There are 0 rows in 0 pages for object "sysmail_attachments_transfer".
DBCC results for 'backupfile'.
There are 4211 rows in 182 pages for object "backupfile".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'restorehistory'.
There are 1 rows in 1 pages for object "restorehistory".
DBCC results for 'sysproxies'.
There are 0 rows in 0 pages for object "sysproxies".
DBCC results for 'restorefile'.
There are 2 rows in 1 pages for object "restorefile".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
February 16, 2013 at 1:12 am
There's no corruption there, so no errors that need fixing.
Service packs are not fixes for database corruption, not that you have any anymore.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply