Post reply

Could not find database ID xx. Database may not be activate

  • November 28, 2006 at 5:45 am

    #115284

    I have the following message when ask the property of the database, using Enterprise Manage:

     

    Could not find database ID 8. Database may not be activate

     

    the result of

    SELECT * FROM master..sysdatabases

    is

    varuna70 8 0x010500000000000515000000806DB83D6BA7A5A4537DB242F4010000 0 1077936153 1090519040 2006-11-27 22:39:28.743 1900-01-01 00:00:00.000 0 80 C:\Arquivos de programas\Microsoft SQL Server\MSSQL\data\varuna70_Data.MDF NULL

     

    Someone could help?

  • November 28, 2006 at 6:24 am

    #674308

    can you post the results of the query

    exec sp_helpdb varuna

    MVDBA

  • November 28, 2006 at 7:21 am

    #674329

    exec sp_helpdb varuna

    or

    exec sp_helpdb varuna70

     

    returns blank.

     

     

    thanks,

     

    Luiz Carlos

  • November 28, 2006 at 7:28 am

    #674336

    varuna70 if thats what your database is called

    MVDBA

  • November 28, 2006 at 7:41 am

    #674347

    sounds like your sql service account does not have permissions for the file

    C:\Arquivos de programas\Microsoft SQL Server\MSSQL\data\varuna70_Data.MDF

    MVDBA

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

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