Post reply

After restore got error 913: Database may not be activated yet or may be in transition

  • April 24, 2009 at 3:49 am

    #133415

    Hello,

    After database restore I executed simple query:

    select * from database.dbo.table1

    where col1 = 111;

    and got following error:

    Msg 913, Level 16, State 8, Line 1

    Could not find database ID 9. Database may not be activated yet or may be in transition.

    The database is up and running and it is not corrupted. When I removed dbo schema name I could get result set, same when I query with other columns

    from the tabel. I would also want to mention that SQL Server is updated (8.0.2040) and as far as I am concerned my problem is not related with KB articles:

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

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

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

    Could you give me some clues to resolve this mystery?

    Regards,

    Bartek

  • April 24, 2009 at 4:52 am

    #983452

    Problem resolved.

    I did some workaround:

    - scripted existing table which caused error

    - created new one with the same objects (indexes, constraints..)

    - copied data to the new one

    - changed table names

    I still do not know what caused this error, and if my solution is repeatable for others who get this strange message but on my SQL Server works :w00t:

    Cheers,

    Bartek

  • April 27, 2009 at 10:47 am

    #984500

    Thanks for the update. Based on that it sounds like some physical issue that you fixed by rebuilding the objects.

    Did you ever run a DBCC CHECKDB?

  • April 28, 2009 at 2:50 am

    #984898

    Hi Steve,

    Yes, I did it. It was one of my first actions becasue queried column was indexed. But I got zero errors.

    Cheers,

    Bartek

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

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