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 |
|
vb_bv
Starting Member
24 Posts |
 Posted - 2002-04-24 : 05:37:53
|
| hi, all, I found a strange SQLServerLog from Enterprise Manager, I don't know why the SQLServerLogs keep continue shows the message below:Starting up database 'XXX'.where the 'XXX' is the name of database, does anyone knows why's that happen or how to fix it.many thanks you guys help. |
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-04-24 : 07:58:44
|
| Not sure if I follow but what you are seeing is typical SQL Server behavoir. When the SQL Server service restarts it has to go through and "start up" each of the databases.Kyle HeonPixelMEDIA, Inc.Programmer L2kheon@pixelmedia.com |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-24 : 09:30:23
|
| If this is a recurring event in the log and you have not restarted your server in awhile, check the database options. If auto close is selected then the database will close after a period of inactivity and reopen when a user tries to connect to it.Jeff BanschbachConsultant, MCDBA |
|
|
|
vb_bv
Starting Member
24 Posts |
Posted - 2002-04-24 : 21:35:41
|
| thanks KHeon and efelito, and efelito, you're right, I found my datasbase setting is enabled the "Auto Close" button, just would like any the disadvantage if I disbale this button?many thanks. |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-25 : 10:28:36
|
| There really aren't any disadvantages in disabling auto close. It is designed to help save resources on infrequently accessed databases. Having it enabled, especially on a production system, can cause serious performance problems. It consumes a lot of extra resources to keep closing and opening the db everytime someone wants to access it.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
|
|
A question from SQLServerLogs