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 |
|
nicolo
Starting Member
20 Posts |
 Posted - 2005-10-17 : 10:27:36
|
| I've been having SQL 2000 startup issues for a while now and upon checking the logs, noticed a bunch of messages about analysis of the database at % completion and recovery complete. Then I see messages about it shutting down and starting back up again. Is this what is causing the problem? What is going on? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-10-17 : 10:35:07
|
| you might have autoclose enabled for some of your databases. check the properties of each database in enterprise manager and disable this option if is enabled.-ec |
 |
|
|
nicolo
Starting Member
20 Posts |
Posted - 2005-10-18 : 09:19:41
|
| Nope, I checked all the databases and the Auto Close option isn't checked off. |
|
|
|
|
|
|
analysis and recovery?