Post reply

issue: The database may be offline. Wait a few minutes and try again

  • February 9, 2011 at 1:38 am

    #231146

    Hello,

    I installed a dotnet application which uses Sql Server Express 2008 on a customer’s standalone computer with a fresh Sql server express 2008 install.

    I can use the application and read or write data on database without problem but after a small time of no activity (approximately 2 minutes), when I try to do the same thing with no problem, I have the message :

    “Could not find database ID 0, name 'Agt00’. The database may be offline. Wait a few minutes and try again“

    Agt00 is the name of the database.

    The unique solution is to quit application the re run.

    I never have this problem with this application from others customers.

    What can I do ?

    Thanks

    Dominique

  • February 9, 2011 at 3:17 am

    #1284303

    dg78 (2/9/2011)

    Hello,

    I installed a dotnet application which uses Sql Server Express 2008 on a customer’s standalone computer with a fresh Sql server express 2008 install.

    I can use the application and read or write data on database without problem but after a small time of no activity (approximately 2 minutes), when I try to do the same thing with no problem, I have the message :

    “Could not find database ID 0, name 'Agt00’. The database may be offline. Wait a few minutes and try again“

    Agt00 is the name of the database.

    The unique solution is to quit application the re run.

    I never have this problem with this application from others customers.

    What can I do ?

    Thanks

    Dominique

    Check the sql server error log & application log too.

    Reply the results

    select name,state_desc from sys.databases

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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