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 - 2005-12-05 : 08:14:37
|
| Donna writes "Have a sqlserver box (I'm an Oracle DBA and new to SQLServer but have books on the way - please excuse my ignorance).This box has numerous databases on it. We installed a database and did not include it in the database maintenance plan. Since that time in the SQLServer logs, I can see where it is trying to startup this database and the others each morning. This new database (TSDATA) is a demo database. If I take it offline, the startup messages for TSDATA and the other databases goes away and I see the standard backup and database maintenance message for the other databases.Have I set something up incorrectly? My impression was that the only time a database would be 'started up' is if the server was rebooted or the MSSQL Service bounced.Any suggestions or white page referrals are most appreciated.Thank you for your time." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-05 : 15:02:56
|
is the database marked as AUTOCLOSE? If so it will "close" when the last concurrent connection is released, and then re-start when a new connection is created. This is great for a laptop . but terrible for a proper server  See Enterprise Manager : Database : Properties : OptionsKristen |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
|
|
|
|
|
Database Setup