Database goes "In Recovery" Mode Automatically

  • Hi Experts,


    I am Using SQL Server Express Edition at client side, and my Database goes "In Recovery" Mode automatically, and comes in normal mode with in seconds


    it repeats 3 to 4 times in 1 Minute.


    Please suggest what to do keep in active mode.



    Mohamad Feroz Patel

    Patel Mohamad

  • Express editions have  a setting called autoclose, which turns off the database when it has been idle for a while in order to save resources, since an express edition is often a developer type machine.

    if this query returns any results at all, those databases need to be modified to turn off autoclose:


    SELECT 'ALTER DATABASE  ' + QUOTENAME(name) + ' SET AUTO_CLOSE OFF', AS fixcmd,* FROM sys.databases WHERE is_auto_close_on = 1


    • This reply was modified 2 years, 9 months ago by  Lowell.


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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