Database goes "In Recovery" Mode Automatically

  • patelmohamad

    SSCommitted

    Points: 1711

    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.

     

    Thanks

    Mohamad Feroz Patel

    Patel Mohamad

  • Lowell

    SSC Guru

    Points: 323349

    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 3 months, 1 week ago by  Lowell.

    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 2 (of 2 total)

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