Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Integrity Error Expand / Collapse
Author
Message
Posted Wednesday, March 03, 2010 7:58 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 21, 2010 1:18 PM
Points: 71, Visits: 380
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.
Post #875988
Posted Wednesday, March 03, 2010 9:39 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 11:17 AM
Points: 4,379, Visits: 9,470
You need to run the following on that database and post the results here:

DBCC CHECKDB({your database}) WITH all_errormsgs, no_infomsgs;

What you posted before does not show the errors and we need to see all of the errors to determine what needs to be done. I would start by identifying a clean backup and start getting prepared to restore from that backup. In most cases, the easiest and best way to recover from an integrity problem is to restore.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #876110
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse