Sql-server – SQL server database start/stop issue

sqlsql serversql-server-2008

I am using SQL Server 2008 Enterprise for development. I find from SQL Server logs, there are items like,

2009-09-20 19:54:33.55 spid53      Starting up database 'DummyOrderDB'.

My confusion is, I think we could only start/stop database server instance (the contained database will be started/stopped when the containing database server instance start/stop), can we just start/stop a database without touch database server instance? I did not find such menu from SSMS.

thanks in advance,

Best Answer

This could also be caused by having the AUTO_CLOSE option set to ON. When this is the case, the database will be stopped after the last user connection to that database is closed. The database will be started again when a new connection is made to the database. The default for SQL Express editions is ON, and OFF for all other server editions.

When set to ON, the database is shut down cleanly and its resources are freed after the last user exits. The database automatically reopens when a user tries to use the database again.

When set to OFF, the database remains open after the last user exits.