This article explains how to turn OFF SQL Database AUTO CLOSE function.

Due to this setting, SQL Server would “close” the database and release all resources once last connection is closed. As soon as first connection is made, it would “open” or “start” the database and make an entry in SQL Server ERRORLOG.SQL Database auto restart.

Detail Steps

  1. Open SQL Management Studio
  2. Select your databas etc. DPLWMSSQL
  3. Right click > Properties
  4. Options > Auto Close > set to False > OK to save the changes




Related Information

SQL Installation