May 10, 2010 at 11:48 am
My SQL Server msdb Integrity job fails with 2 consitency errors. Unfortnately there are no good backups to do a restore. The database is not in suspect mode and msdb backups completes successfully. Need help
Below is the message
Job 'msdb_WeeklyIntegrityCheck' : Step 1, 'Run msdb_WeeklyIntegrityCheck' : Began Executing 2010-05-08 00:11:55
DBCC results for 'msdb'. [SQLSTATE 01000]
Warning: NO_INDEX option of CHECKDB being used. Checks on non-system indexes will be skipped. [SQLSTATE 01000]
DBCC results for 'sysobjects'. [SQLSTATE 01000]
There are 417 rows in 8 pages for object 'sysobjects'. [SQLSTATE 01000]
DBCC results for 'sysindexes'. [SQLSTATE 01000]
There are 214 rows in 9 pages for object 'sysindexes'. [SQLSTATE 01000]
DBCC results for 'syscolumns'. [SQLSTATE 01000]
There are 3568 rows in 124 pages for object 'syscolumns'. [SQLSTATE 01000]
DBCC results for 'systypes'. [SQLSTATE 01000]
There are 26 rows in 1 pages for object 'systypes'. [SQLSTATE 01000]
DBCC results for 'syscomments'. [SQLSTATE 01000]
There are 424 rows in 164 pages for object 'syscomments'. [SQLSTATE 01000]
DBCC results for 'sysfiles1'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'sysfiles1'. [SQLSTATE 01000]
DBCC results for 'syspermissions'. [SQLSTATE 01000]
There are 183 rows in 1 pages for object 'syspermissions'. [SQLSTATE 01000]
DBCC results for 'sysusers'. [SQLSTATE 01000]
There are 14 rows in 1 pages for object 'sysusers'. [SQLSTATE 01000]
DBCC results for 'sysproperties'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysproperties'. [SQLSTATE 01000]
DBCC results for 'sysdepends'. [SQLSTATE 01000]
There are 2655 rows in 17 pages for object 'sysdepends'. [SQLSTATE 01000]
DBCC results for 'sysreferences'. [SQLSTATE 01000]
There are 12 rows in 1 pages for object 'sysreferences'. [SQLSTATE 01000]
DBCC results for 'sysfulltextcatalogs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'. [SQLSTATE 01000]
DBCC results for 'sysfulltextnotify'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysfulltextnotify'. [SQLSTATE 01000]
DBCC results for 'sysfilegroups'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'sysfilegroups'. [SQLSTATE 01000]
DBCC results for 'sysjobschedules'. [SQLSTATE 01000]
There are 36 rows in 1 pages for object 'sysjobschedules'. [SQLSTATE 01000]
DBCC results for 'RTblIfaceMem'. [SQLSTATE 01000]
There are 1186 rows in 9 pages for object 'RTblIfaceMem'. [SQLSTATE 01000]
DBCC results for 'backupfile'. [SQLSTATE 01000]
There are 2534 rows in 60 pages for object 'backupfile'. [SQLSTATE 01000]
DBCC results for 'syscategories'. [SQLSTATE 01000]
There are 19 rows in 1 pages for object 'syscategories'. [SQLSTATE 01000]
DBCC results for 'systargetservers'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'systargetservers'. [SQLSTATE 01000]
DBCC results for 'RTblWorkspaceItems'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblWorkspaceItems'. [SQLSTATE 01000]
DBCC results for 'restorehistory'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'restorehistory'. [SQLSTATE 01000]
DBCC results for 'systargetservergroups'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'systargetservergroups'. [SQLSTATE 01000]
DBCC results for 'RTblDatabaseVersion'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'RTblDatabaseVersion'. [SQLSTATE 01000]
DBCC results for 'systargetservergroupmembers'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'systargetservergroupmembers'. [SQLSTATE 01000]
DBCC results for 'sysalerts'. [SQLSTATE 01000]
There are 9 rows in 1 pages for object 'sysalerts'. [SQLSTATE 01000]
DBCC results for 'RTblDTSProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblDTSProps'. [SQLSTATE 01000]
DBCC results for 'RTblVersionAdminInfo'. [SQLSTATE 01000]
There are 2328 rows in 30 pages for object 'RTblVersionAdminInfo'. [SQLSTATE 01000]
DBCC results for 'restorefile'. [SQLSTATE 01000]
There are 4 rows in 1 pages for object 'restorefile'. [SQLSTATE 01000]
DBCC results for 'sysoperators'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysoperators'. [SQLSTATE 01000]
DBCC results for 'sysnotifications'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysnotifications'. [SQLSTATE 01000]
DBCC results for 'RTblParameterDef'. [SQLSTATE 01000]
There are 136 rows in 1 pages for object 'RTblParameterDef'. [SQLSTATE 01000]
DBCC results for 'restorefilegroup'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object 'restorefilegroup'. [SQLSTATE 01000]
DBCC results for 'systaskids'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'systaskids'. [SQLSTATE 01000]
DBCC results for 'syscachedcredentials'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'syscachedcredentials'. [SQLSTATE 01000]
DBCC results for 'RTblIfaceHier'. [SQLSTATE 01000]
There are 3345 rows in 18 pages for object 'RTblIfaceHier'. [SQLSTATE 01000]
DBCC results for 'logmarkhistory'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'logmarkhistory'. [SQLSTATE 01000]
DBCC results for 'RTblNamedObj'. [SQLSTATE 01000]
There are 2191 rows in 22 pages for object 'RTblNamedObj'. [SQLSTATE 01000]
DBCC results for 'sysdtscategories'. [SQLSTATE 01000]
There are 3 rows in 1 pages for object 'sysdtscategories'. [SQLSTATE 01000]
DBCC results for 'sysdtspackages'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysdtspackages'. [SQLSTATE 01000]
DBCC results for 'RTblTypeInfo'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblTypeInfo'. [SQLSTATE 01000]
DBCC results for 'sysdtspackagelog'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysdtspackagelog'. [SQLSTATE 01000]
DBCC results for 'RTblScriptDefs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblScriptDefs'. [SQLSTATE 01000]
DBCC results for 'RTblOLPProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblOLPProps'. [SQLSTATE 01000]
DBCC results for 'sysdtssteplog'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysdtssteplog'. [SQLSTATE 01000]
DBCC results for 'RTblEnumerationDef'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblEnumerationDef'. [SQLSTATE 01000]
DBCC results for 'sysdtstasklog'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysdtstasklog'. [SQLSTATE 01000]
DBCC results for 'RTblSumInfo'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblSumInfo'. [SQLSTATE 01000]
DBCC results for 'RTblMDSProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblMDSProps'. [SQLSTATE 01000]
DBCC results for 'RTblEnumerationValueDef'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'. [SQLSTATE 01000]
DBCC results for 'RTblUMLProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblUMLProps'. [SQLSTATE 01000]
DBCC results for 'sysdbmaintplans'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object 'sysdbmaintplans'. [SQLSTATE 01000]
DBCC results for 'sysdbmaintplan_jobs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysdbmaintplan_jobs'. [SQLSTATE 01000]
DBCC results for 'RTblUMXProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblUMXProps'. [SQLSTATE 01000]
DBCC results for 'sysdbmaintplan_databases'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysdbmaintplan_databases'. [SQLSTATE 01000]
DBCC results for 'RTblSIMProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblSIMProps'. [SQLSTATE 01000]
DBCC results for 'sysdbmaintplan_history'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'sysdbmaintplan_history'. [SQLSTATE 01000]
DBCC results for 'RTblGENProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblGENProps'. [SQLSTATE 01000]
DBCC results for 'RTblDTMProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblDTMProps'. [SQLSTATE 01000]
DBCC results for 'log_shipping_primaries'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'log_shipping_primaries'. [SQLSTATE 01000]
DBCC results for 'log_shipping_secondaries'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'log_shipping_secondaries'. [SQLSTATE 01000]
DBCC results for 'RTblDBMProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblDBMProps'. [SQLSTATE 01000]
DBCC results for 'RTblEQMProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblEQMProps'. [SQLSTATE 01000]
DBCC results for 'log_shipping_monitor'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'log_shipping_monitor'. [SQLSTATE 01000]
DBCC results for 'mswebtasks'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'mswebtasks'. [SQLSTATE 01000]
DBCC results for 'log_shipping_databases'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'log_shipping_databases'. [SQLSTATE 01000]
DBCC results for 'log_shipping_plans'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'log_shipping_plans'. [SQLSTATE 01000]
DBCC results for 'RTblVersions'. [SQLSTATE 01000]
There are 2328 rows in 27 pages for object 'RTblVersions'. [SQLSTATE 01000]
DBCC results for 'log_shipping_plan_databases'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'log_shipping_plan_databases'. [SQLSTATE 01000]
DBCC results for 'log_shipping_plan_history'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'log_shipping_plan_history'. [SQLSTATE 01000]
DBCC results for 'RTblDBXProps'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object 'RTblDBXProps'. [SQLSTATE 01000]
DBCC results for 'RTblRelships'. [SQLSTATE 01000]
There are 6910 rows in 146 pages for object 'RTblRelships'. [SQLSTATE 01000]
DBCC results for 'RTblSites'. [SQLSTATE 01000]
There are 38 rows in 1 pages for object 'RTblSites'. [SQLSTATE 01000]
DBCC results for 'RTblProps'. [SQLSTATE 01000]
There are 392 rows in 3 pages for object 'RTblProps'. [SQLSTATE 01000]
DBCC results for 'RTblRelshipProps'. [SQLSTATE 01000]
There are 28 rows in 1 pages for object 'RTblRelshipProps'. [SQLSTATE 01000]
DBCC results for 'RTblPropDefs'. [SQLSTATE 01000]
There are 794 rows in 10 pages for object 'RTblPropDefs'. [SQLSTATE 01000]
DBCC results for 'RTblRelColDefs'. [SQLSTATE 01000]
There are 320 rows in 4 pages for object 'RTblRelColDefs'. [SQLSTATE 01000]
DBCC results for 'RTblIfaceDefs'. [SQLSTATE 01000]
There are 452 rows in 5 pages for object 'RTblIfaceDefs'. [SQLSTATE 01000]
DBCC results for 'backupmediaset'. [SQLSTATE 01000]
Msg 8928, Sev 16: Object ID 2117582582, index ID 0: Page (1:1518) could not be processed. See other errors for details. [SQLSTATE 42000]
Msg 8939, Sev 16: Table error: Object ID 2117582582, index ID 0, page (1:1518). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1. [SQLSTATE 42000]
Msg 2593, Sev 16: There are 7 rows in 1 pages for object 'backupmediaset'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sqlagent_info'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'sqlagent_info'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'RTblClassDefs'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 537 rows in 5 pages for object 'RTblClassDefs'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysdownloadlist'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'sysdownloadlist'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'backupmediafamily'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 7 rows in 1 pages for object 'backupmediafamily'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysjobhistory'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1000 rows in 110 pages for object 'sysjobhistory'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysjobs'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 36 rows in 2 pages for object 'sysjobs'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'RTblTFMProps'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 0 rows in 0 pages for object 'RTblTFMProps'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'RTblRelshipDefs'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 144 rows in 1 pages for object 'RTblRelshipDefs'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'backupset'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 1245 rows in 58 pages for object 'backupset'. [SQLSTATE 01000]
Msg 8990, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in table 'backupset' (object ID 2117582582). [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysjobservers'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 36 rows in 2 pages for object 'sysjobservers'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'RTblTypeLibs'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 16 rows in 1 pages for object 'RTblTypeLibs'. [SQLSTATE 01000]
Msg 2536, Sev 16: DBCC results for 'sysjobsteps'. [SQLSTATE 01000]
Msg 2593, Sev 16: There are 36 rows in 3 pages for object 'sysjobsteps'. [SQLSTATE 01000]
Msg 8989, Sev 16: CHECKDB found 0 allocation errors and 2 consistency errors in database 'msdb'. [SQLSTATE 01000]
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (msdb noindex). [SQLSTATE 01000]
DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]
Kus Kus
May 11, 2010 at 7:37 am
Hi,
Generally restore from a backup is a good option here, but as you said, the backups do not exist now, may be re-building MSDB might be the next option. But all the jobs and DTS needs to be backed up first. Re-building will also clean up the history information from the history tables.
Thank you
[font="Verdana"]Renuka__[/font]
May 11, 2010 at 9:00 am
Thanks for you response. In rebuilding can I just run the instmsdb.sql script? I can recreate the jobs if it gets wiped out.
May 11, 2010 at 9:08 am
Hi,
-->Start SQL service with trace flag -T3608 (which prevents SQL server from automatically starting and recovering any database except Master database).
--> Rebuild MSDB using INSTMSDB.sql from service pack files
Thank you
[font="Verdana"]Renuka__[/font]
May 11, 2010 at 1:12 pm
Thanks, I tried what you suggested.
These are the steps I used.
- In SQL Server Enterprise Manager, right-click the server name and
click Properties.
- On the General tab, clicked Startup Parameters.
- Add a new parameter as "-T3608" (without the quotation marks).
After adding the Trace Flag I Stopped, and then restarted SQL Server.
Made sure that the SQL Server Agent service was not running.
Detached the msdb database as follows:
use master
go
sp_detach_db 'msdb'
go
Moved the msdb data and log files to a different location
Run the INSTMSDB.SQL script
Remove the -T3608 trace flag from the startup parameters box in
Enterprise Manager
Stopped, and then restarted SQL Server.
The instlmsdb.sql script completed with no errors but I have these questions/issues
The rebuild msdb is missing all user tables such as log_shipping_database, log_shipping_monitor , RTblClassDefs etc.
and also missing all user stored procedures such as r_iRTblOLPProps, r_iRTblClassDefs etc.
Does that look right? I have to do this on a production database and I want to make sure I am doing the right thing.
It would be tested adequately before the final implementation but the missing tables and sprocs scares me.
Help!!!!!!!!!!!!!!! needed.
Thanks.
May 12, 2010 at 3:02 pm
I restored a copy of the corrupted msdb on my local server and I run this query
ALTER DATABASE msdb
SET single_user WITH ROLLBACK IMMEDIATE;
go
DBCC checkdb ('msdb', repair_allow_data_loss);
go
ALTER DATABASE msdb
SET Multi_user WITH ROLLBACK IMMEDIATE ;
go
The output is as follows
Nonqualified transactions are being rolled back. Estimated rollback completion: 100%.
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 417 rows in 8 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 221 rows in 9 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3568 rows in 124 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 424 rows in 164 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 183 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 14 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2655 rows in 17 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 12 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysjobschedules'.
There are 36 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'RTblIfaceMem'.
There are 1186 rows in 9 pages for object 'RTblIfaceMem'.
DBCC results for 'backupfile'.
There are 2594 rows in 61 pages for object 'backupfile'.
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'RTblWorkspaceItems'.
There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
DBCC results for 'restorehistory'.
There are 3 rows in 1 pages for object 'restorehistory'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'RTblDatabaseVersion'.
There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'RTblDTSProps'.
There are 0 rows in 0 pages for object 'RTblDTSProps'.
DBCC results for 'RTblVersionAdminInfo'.
There are 2328 rows in 30 pages for object 'RTblVersionAdminInfo'.
DBCC results for 'restorefile'.
There are 6 rows in 1 pages for object 'restorefile'.
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 'RTblParameterDef'.
There are 136 rows in 1 pages for object 'RTblParameterDef'.
DBCC results for 'restorefilegroup'.
There are 3 rows in 1 pages for object 'restorefilegroup'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 0 rows in 0 pages for object 'syscachedcredentials'.
DBCC results for 'RTblIfaceHier'.
There are 3345 rows in 18 pages for object 'RTblIfaceHier'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'RTblNamedObj'.
There are 2191 rows in 22 pages for object 'RTblNamedObj'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'sysdtspackages'.
There are 0 rows in 0 pages for object 'sysdtspackages'.
DBCC results for 'RTblTypeInfo'.
There are 0 rows in 0 pages for object 'RTblTypeInfo'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'RTblScriptDefs'.
There are 0 rows in 0 pages for object 'RTblScriptDefs'.
DBCC results for 'RTblOLPProps'.
There are 0 rows in 0 pages for object 'RTblOLPProps'.
DBCC results for 'sysdtssteplog'.
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'RTblEnumerationDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'RTblSumInfo'.
There are 0 rows in 0 pages for object 'RTblSumInfo'.
DBCC results for 'RTblMDSProps'.
There are 0 rows in 0 pages for object 'RTblMDSProps'.
DBCC results for 'RTblEnumerationValueDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
DBCC results for 'RTblUMLProps'.
There are 0 rows in 0 pages for object 'RTblUMLProps'.
DBCC results for 'sysdbmaintplans'.
There are 1 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'RTblUMXProps'.
There are 0 rows in 0 pages for object 'RTblUMXProps'.
DBCC results for 'sysdbmaintplan_databases'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'RTblSIMProps'.
There are 0 rows in 0 pages for object 'RTblSIMProps'.
DBCC results for 'sysdbmaintplan_history'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_history'.
DBCC results for 'RTblGENProps'.
There are 0 rows in 0 pages for object 'RTblGENProps'.
DBCC results for 'RTblDTMProps'.
There are 0 rows in 0 pages for object 'RTblDTMProps'.
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 'RTblDBMProps'.
There are 0 rows in 0 pages for object 'RTblDBMProps'.
DBCC results for 'RTblEQMProps'.
There are 0 rows in 0 pages for object 'RTblEQMProps'.
DBCC results for 'log_shipping_monitor'.
There are 0 rows in 0 pages for object 'log_shipping_monitor'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'log_shipping_databases'.
There are 0 rows in 0 pages for object 'log_shipping_databases'.
DBCC results for 'log_shipping_plans'.
There are 0 rows in 0 pages for object 'log_shipping_plans'.
DBCC results for 'RTblVersions'.
There are 2328 rows in 27 pages for object 'RTblVersions'.
DBCC results for 'log_shipping_plan_databases'.
There are 0 rows in 0 pages for object 'log_shipping_plan_databases'.
DBCC results for 'log_shipping_plan_history'.
There are 0 rows in 0 pages for object 'log_shipping_plan_history'.
DBCC results for 'RTblDBXProps'.
There are 0 rows in 0 pages for object 'RTblDBXProps'.
DBCC results for 'RTblRelships'.
There are 6910 rows in 146 pages for object 'RTblRelships'.
DBCC results for 'RTblSites'.
There are 38 rows in 1 pages for object 'RTblSites'.
DBCC results for 'RTblProps'.
There are 392 rows in 3 pages for object 'RTblProps'.
DBCC results for 'RTblRelshipProps'.
There are 28 rows in 1 pages for object 'RTblRelshipProps'.
DBCC results for 'RTblPropDefs'.
There are 794 rows in 10 pages for object 'RTblPropDefs'.
DBCC results for 'RTblRelColDefs'.
There are 320 rows in 4 pages for object 'RTblRelColDefs'.
DBCC results for 'RTblIfaceDefs'.
There are 452 rows in 5 pages for object 'RTblIfaceDefs'.
DBCC results for 'backupmediaset'.
There are 8 rows in 1 pages for object 'backupmediaset'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'RTblClassDefs'.
There are 537 rows in 5 pages for object 'RTblClassDefs'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediafamily'.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 2117582582, index ID 0: Page (1:1518) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 2117582582, index ID 0, page (1:1518). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 2117582582, index ID 1. Page (1:1518) was not seen in the scan although its parent (1:1404) and previous (1:1517) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 2117582582, index ID 1. Page (1:1519) is missing a reference from previous page (1:1518). Possible chain linkage problem.
There are 8 rows in 1 pages for object 'backupmediafamily'.
DBCC results for 'sysjobhistory'.
There are 1000 rows in 108 pages for object 'sysjobhistory'.
DBCC results for 'sysjobs'.
There are 36 rows in 2 pages for object 'sysjobs'.
DBCC results for 'RTblTFMProps'.
There are 0 rows in 0 pages for object 'RTblTFMProps'.
DBCC results for 'RTblRelshipDefs'.
There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
DBCC results for 'backupset'.
The error has been repaired.
The error has been repaired.
The error has been repaired.
The error has been repaired.
Repair: Page (1:1518) has been deallocated from object ID 2117582582, index ID 0.
Clustered index successfully restored for object 'dbo.backupset' in database 'msdb'.
There are 1275 rows in 60 pages for object 'backupset'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'backupset' (object ID 2117582582).
CHECKDB fixed 0 allocation errors and 4 consistency errors in table 'backupset' (object ID 2117582582).
DBCC results for 'sysjobservers'.
There are 36 rows in 2 pages for object 'sysjobservers'.
DBCC results for 'RTblTypeLibs'.
There are 16 rows in 1 pages for object 'RTblTypeLibs'.
DBCC results for 'sysjobsteps'.
There are 36 rows in 3 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 4 consistency errors in database 'msdb'.
CHECKDB fixed 0 allocation errors and 4 consistency errors in database 'msdb'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Now if I run the dbcc checkdb('msdb' noidnex) it shows CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'. [SQLSTATE 01000]
DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]
I am yet to run it inthe production environment....
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply