Database goes "In Recovery" Mode Automatically

• patelmohamad

  SSCommitted

  Points: 1873

  More actions

  April 10, 2019 at 10:03 am

  #3087463

  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: 323518

  More actions

  April 10, 2019 at 12:55 pm

  #3090264

  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 5 years, 11 months 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!