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 - 2004-03-24 : 08:48:35
|
| Troy writes "SQL2000 SP3: I am getting an entry in the log every few seconds or minutes that a database is starting up.When SQL starts I get this entry:Starting up database 'master'Starting up database 'model'...Skipping startup of clean database id 14......Recovery complete.An entry is then logged every few seconds or minutes:Starting up database 'dbDataEntry'Database 'dbDataEntry' is id 14 that was skipped during startup.I can access the databases OK, but the server seems to be running very slow. I have tried to reboot and it hasn't helped.Any ideas?Thanks!" |
|
|
sphadke
Yak Posting Veteran
55 Posts |
Posted - 2004-03-24 : 10:34:15
|
| Check your SQL Server Error Logs and see whats going on there!Sachin |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-24 : 12:25:22
|
| Sachin, that's what Troy is referring to is the SQL Server Error Log.Right click on each of your databases and go to properties. Then go to Options tab. Unselect AUTO CLOSE option. Do this for each of the databases.Tara |
|
|
|
sphadke
Yak Posting Veteran
55 Posts |
Posted - 2004-03-24 : 12:34:31
|
| oh yeah thats right. Thanks for pointing that out TaraSachin |
|
|
|
|
|
|
Starting up database 'dbDataEntry'