Post reply

dbcc check db error

  • July 24, 2007 at 7:58 am

    #175426

    Hi All,

            I ran dbcc check db on one of our databases and it failed with the following message.Could anyone please let me know if id this is fixable.

     

    Thanks

     

    Executed as user: ISO\mosssvc. ...ssage 2536)  DBCC results for 'sys.sysrowsetcolumns'. [SQLSTATE 01000] (Message 2536)  There are 3053 rows in 23 pages for object "sys.sysrowsetcolumns". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysrowsets'. [SQLSTATE 01000] (Message 2536)  There are 289 rows in 2 pages for object "sys.sysrowsets". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sysallocunits'. [SQLSTATE 01000] (Message 2536)  There are 301 rows in 5 pages for object "sysallocunits". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.sysfiles1'. [SQLSTATE 01000] (Message 2536)  There are 17 rows in 3 pages for object "sys.sysfiles1". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.syshobtcolumns'. [SQLSTATE 01000] (Message 2536)  There are 3053 rows in 27 pages for object "sys.syshobtcolumns". [SQLSTATE 01000] (Message 2593)  DBCC results for 'sys.syshobts'. [SQLSTATE 01000] (Message 2536)  There are 289 rows in 2 pages for object "sys.syshobts". [SQLSTATE 01...  The step failed.

  • July 24, 2007 at 8:07 am

    #721925

    Error message is not complete. Can you put a log file and track and post the error as in the log file.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 24, 2007 at 8:30 am

    #721936

    from where exactly do you mean...sql error log file?..because this is the message in the job history...

     

    Thanks

  • July 25, 2007 at 9:34 am

    #722345

    Have you run the DBCC CheckDB in Query Analyzer and see the output?

Viewing 4 posts - 1 through 3 (of 3 total)

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