Search

Monday, January 16, 2012

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

The database may be offline. Wait a few minutes and try again
The above error is coming while accessing the Database. But before 10 minutes it was working fine.


To resolve this problem you have to check the database properties to see if the AutoClose parameter is not set to On. 
When this parameter is On SQL closes the database in auto and then when a new connection tries to get or add data to this database SQL turn it on again.


This parameter can be found If you open the SSMS then right click on the database - click on Properties in the properties window click on the options menu you will find the Auto Close parameter in there.

4 comments:

  1. Hi thanks for the feedback. However, I do have an application that automatically creates databases. The unfortunate thing is they are always in Auto Close (ON). How do I go around the problem

    ReplyDelete
    Replies
    1. Hi
      You had to install SQL Server Management Studio to make changes in database properties.

      Delete
  2. Thank you. This fixed my problem although I have no idea how it got in this state.

    Regards,
    Ken Sherman

    ReplyDelete
  3. Thank you, my problem solved

    ReplyDelete