Post reply

MSDE7 Currupt DB

  • August 9, 2006 at 9:12 pm

    #173766

    I get this error when trying to attach or access the database:

    Error: 906, Severity: 22, State: 2

    Could not locate row in sysobjects for system catalog 'Sysobjects' in database 'DB1'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.

    I can trick MSDE into seeing the database using another database but still can't get into the database even with Query Analyzer. Query Analyzer says:

    Server: Msg 945, Level 14, State 2

    [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'DB1' cannot be opened because some of the files could not be activated.

    The database hasn't been used in months so all the backups are also currupt.

    Anybody know how to repair the MDF file itself?

  • August 14, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • December 23, 2006 at 6:29 pm

    #679892

    Sorry,

    But I have same trouble and I think that not has solution. kkk

    I´m usign SQL 7

  • December 23, 2006 at 10:33 pm

    #679897

    I don't think there is any way to repair mdf file...

    You can try the following...

    1. Backup your mdf and ldf files...

    2. Rename mdf to mdf_old and ldf to ldf_old

    3. Create new db with same name and same mdf and ldf files as problematic db...

    4. Stop the sql service.

    5. Rename new mdf and ldf file to mdf_new, ldf_new

    6. Rename mdf_old to mdf and ldf_old to ldf..

    7. Restart the db..

    8. If there is any issue you may see the db as suspect mode...

    9. Try to bring db in emgerncy mode and take out all the data ...

     

    MohammedU
    Microsoft SQL Server MVP

  • December 24, 2006 at 3:20 am

    #679902

    Dear Friend,

     

    I´m just tried this and after run the dbcc commands for repair my database and nothing.

     

    But Thank you very much

  • December 24, 2006 at 3:29 pm

    #679910

    after run the dbcc commands for repair my database and nothing.

    What do mean by "Repair my db and nothing"

    Check the following article..

    http://support.microsoft.com/kb/236989

    http://support.microsoft.com/kb/158586

    MohammedU
    Microsoft SQL Server MVP

  • January 2, 2007 at 10:45 pm

    #680895

    Hi,

    Server: Msg 945, Level 14, State 2

    [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'DB1' cannot be opened because some of the files could not be activated.

    This problem arises if the database have :
     

    • More than 1 log ( ldf) file

    • One of the log file is deleted or renamed

    • Use sp_attach_db

    • Check whether you have supplied all the log file correctly.

     
    Worried as you do not have any backups.
     
     
    Regards,
    Minaz Amin

       

    "More Green More Oxygen !! Plant a tree today"

  • September 7, 2008 at 11:41 am

    #868240

    Download here http://www.nucleusdatarecovery.org/downloads/kernelsqldemo.exe

    It recovers my MDF

Viewing 8 posts - 1 through 7 (of 7 total)

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