Database Integrity Error

  • 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.

  • 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
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply