DBCC CHECKDB Errors

  • Received this from maint plan:

    Server: Msg 7995, Level 16, State 1, Line 1

    Database 'on_track_reporting' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Anyone else seen this before I call MS?

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • Onced, if I remember correctly DBCC UPDATEUSAGE may correct this. Also,I'd run DBCC CHECKDB from QA (using NO_INFOMSGS etc). Record all errors. Search

    KB etc. Possibly restore latest backup. Or, if backup and KB doesn't help,

    contact MS PSS.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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