Post reply

DB suspect db not exist in Master

  • December 4, 2007 at 1:30 pm

    #201527

    Hi!

    I am having a problem with one of my local data bases, it shown the status of (suspect).

    When I try to apply solutions that I found on internet for example run:

    sp_resetstatus 'dbImpOfer'

    it shows the message that : The databse 'dbImpOfertas' does not exist.

    Use sp_help to show available databases.

  • December 4, 2007 at 3:44 pm

    #757159

    This is the log information:

    2007-11-28 00:00:03.68 spid53 Starting up database 'bdImpOfertas'.

    2007-11-28 00:00:03.76 spid53 Error: 602, Severity: 21, State: 50

    2007-11-28 00:00:03.76 spid53 Could not find row in sysindexes for database ID 15, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes..

    2007-11-28 00:00:05.21 spid53 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_instance_regread'.

    2007-11-28 00:00:05.21 spid54 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_instance_regread'.

  • December 4, 2007 at 5:35 pm

    #757180

    Hi Teresita,

    First off, you're running 2000, not 2005 (this forum) - the 602 error message you posted is the 2000 version. The sysindexes table is corrupt - it can't find an entry for the sysobjects table. These are critical metadata tables that the database can't do without - you have to restore from a backup to fix this - there's no other way to do it.

    Thanks

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

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

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