Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-17 : 08:28:27
|
| Naveed writes "i read an article that mention do not use auto close option in multiuser environmnet. Enterprise Manager->Database->salesdb->properties->Auto Close (checked).Is it important to close database, once we used, if yes then how?. please help me!" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-07-17 : 20:16:20
|
No, you don't need to worry about closing your database unless you are trying to do some OS level work on the database files. Otherwise, just let it run.Here's some info out of Books Online:quote:
AUTO_CLOSEWhen set to ON, the database is closed and shut down cleanly when the last user of the database exits and all processes in the database complete, thereby freeing any resources. By default, this option is set to ON for all databases when using Microsoft® SQL Server™ 2000 Desktop Engine, and OFF for all other editions, regardless of operating system. The database reopens automatically when a user tries to use the database again. If the database was shut down cleanly, the database is not reopened until a user tries to use the database the next time SQL Server is restarted. When set to OFF, the database remains open even if no users are currently using the database.The AUTO_CLOSE option is useful for desktop databases because it allows database files to be managed as normal files. They can be moved, copied to make backups, or even e-mailed to other users. The AUTO_CLOSE option should not be used for databases accessed by an application that repeatedly makes and breaks connections to SQL Server. The overhead of closing and reopening the database between each connection will impair performance.
|
 |
|
|
|
|
|
|
|
Database Close