What is the Auto-Close option when creating a new database in SQL Server 2008?

Question

What is the Auto-Close option when creating a new database in SQL Server 2008?

EDIT: and how do you decide whether to turn it on or off?

Answer 1

From MSDN:

If True, the database is closed, and its resources are freed when no user connection accesses the database. If False (default), the server maintains the database in an open and ready state regardless of user activity..

Edit to answer edited in question: It all depends on whether the server needs the extra memory, and if the time cost to open and close the database is worth the extra memory gained. If you are unsure, then false is probably the way to go.

Answer 2

In short, don't enable it on production ever

Only enable if the database is accessed infrequently (such as Dev/QA)

Answer 3

yes, but have a question: if autoclose is false,when the database makes backup ,other peopel can connect the database? and stay users connection to open status or close the users connection and makes the database backup?

Answer 4

Set Auto Close to false if you are using database mirroring in SQL Server 2008.