Integrity job - 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)

Integrity job

Author

Topic

DBA007
Posting Yak Master

145 Posts

Posted - 2010-03-03 : 08:15:10

Team,
My databaseIntegrity job has failed stating the error as follows,iam using the script to do this

Service Broker Msg 9675, State 1: Message Types analyzed: 14. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9667, State 1: Services analyzed: 3. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9668, State 1: Service Queues analyzed: 3. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. [SQLSTATE 01000] (Message 8997) Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. [SQLSTATE 01000] (Message 8997) DBCC results for 'sys.sysrowsetcolumns'. [SQLSTATE 01000] (Message 2536) There are 714 rows in 7 pages for object "sys.sysrowsetcolumns". [SQLSTATE 01000] (Message 2593) DBCC results for 'sys.sysrowsets'. [SQLSTATE 01000] (Message 2536) There are 104 rows in 1 pages for ... The step failed.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-03-03 : 10:58:59

There's not enough information in there.

Please run the following on the database in question and post full output.


DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

If that returns no errors, then log the output of the maint plan to file and post the contents of the file.

--
Gail Shaw
SQL Server MVP

DBA007
Posting Yak Master

145 Posts

Posted - 2010-03-03 : 15:12:07

Thanks Gail,but when i run the job manually it is working fine but according to the schedule it is failing thrice in a week,and i dont find any error messages in the output file of the plan,except statements of these type

DBCC results for 'master'. [SQLSTATE 01000]
Service Broker Msg 9675, State 1: Message Types analyzed: 14. [SQLSTATE 01000]
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. [SQLSTATE 01000]
Service Broker Msg 9667, State 1: Services analyzed: 3. [SQLSTATE 01000]
Service Broker Msg 9668, State 1: Service Queues analyzed: 3. [SQLSTATE 01000]
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0. [SQLSTATE 01000]
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0. [SQLSTATE 01000]
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0. [SQLSTATE 01000]
DBCC results for 'sys.sysrowsetcolumns'. [SQLSTATE 01000]
There are 714 rows in 7 pages for object "sys.sysrowsetcolumns". [SQLSTATE 01000]
DBCC results for 'sys.sysrowsets'. [SQLSTATE 01000]
There are 104 rows in 1 pages for object "sys.sysrowsets". [SQLSTATE 01000]
DBCC results for 'sysallocunits'. [SQLSTATE 01000]
There are 115 rows in 2 pages for object "sysallocunits". [SQLSTATE 01000]
DBCC results for 'sys.sysfiles1'. [SQLSTATE 01000]
There are 2 rows in 1 pages for object "sys.sysfiles1". [SQLSTATE 01000]
DBCC results for 'sys.syshobtcolumns'. [SQLSTATE 01000]
There are 714 rows in 7 pages for object "sys.syshobtcolumns". [SQLSTATE 01000]
DBCC results for 'sys.syshobts'. [SQLSTATE 01000]
There are 104 rows in 1 pages for object "sys.syshobts". [SQLSTATE 01000]
DBCC results for 'sys.sysftinds'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysftinds". [SQLSTATE 01000]
DBCC results for 'sys.sysserefs'. [SQLSTATE 01000]
There are 115 rows in 1 pages for object "sys.sysserefs". [SQLSTATE 01000]
DBCC results for 'sys.sysowners'. [SQLSTATE 01000]
There are 44 rows in 1 pages for object "sys.sysowners". [SQLSTATE 01000]
DBCC results for 'sys.sysdbreg'. [SQLSTATE 01000]
There are 13 rows in 1 pages for object "sys.sysdbreg". [SQLSTATE 01000]
DBCC results for 'sys.sysprivs'. [SQLSTATE 01000]
There are 1857 rows in 17 pages for object "sys.sysprivs". [SQLSTATE 01000]
DBCC results for 'sys.sysschobjs'. [SQLSTATE 01000]
There are 93 rows in 3 pages for object "sys.sysschobjs". [SQLSTATE 01000]
DBCC results for 'sys.syslogshippers'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.syslogshippers". [SQLSTATE 01000]
DBCC results for 'sys.syscolpars'. [SQLSTATE 01000]
There are 592 rows in 10 pages for object "sys.syscolpars". [SQLSTATE 01000]
DBCC results for 'sys.sysxlgns'. [SQLSTATE 01000]
There are 54 rows in 1 pages for object "sys.sysxlgns". [SQLSTATE 01000]
DBCC results for 'sys.sysxsrvs'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object "sys.sysxsrvs". [SQLSTATE 01000]
DBCC results for 'sys.sysnsobjs'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object "sys.sysnsobjs". [SQLSTATE 01000]
DBCC results for 'sys.sysusermsgs'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysusermsgs". [SQLSTATE 01000]
DBCC results for 'sys.syscerts'. [SQLSTATE 01000]
There are 5 rows in 1 pages for object "sys.syscerts". [SQLSTATE 01000]
DBCC results for 'sys.sysrmtlgns'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysrmtlgns". [SQLSTATE 01000]
DBCC results for 'sys.syslnklgns'. [SQLSTATE 01000]
There are 1 rows in 1 pages for object "sys.syslnklgns". [SQLSTATE 01000]
DBCC results for 'sys.sysxprops'. [SQLSTATE 01000]
There are 0 rows in 0 pages for object "sys.sysxprops". [SQLSTATE 01000]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources