Numerous events - Starting up database 'Database_name'.

I have an SQL server with 2000 SE installed. I noticed in the SQL logs that
my server is constantly trying to start one database on numerous occasions. I
must have over 70 entries for this single database. Has anyone experienced
this problem before?
Nick
Seems ,that database's option AutoClose set ON
"Nick Pennisi" <NickPennisi@.discussions.microsoft.com> wrote in message
news:1BE05286-4681-4BA8-B9EE-9EA05E376BDB@.microsoft.com...
>I have an SQL server with 2000 SE installed. I noticed in the SQL logs that
> my server is constantly trying to start one database on numerous
> occasions. I
> must have over 70 entries for this single database. Has anyone experienced
> this problem before?
|||Turn off the autoclose database property. This also hurts performance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Nick Pennisi" <NickPennisi@.discussions.microsoft.com> wrote in message
news:1BE05286-4681-4BA8-B9EE-9EA05E376BDB@.microsoft.com...
>I have an SQL server with 2000 SE installed. I noticed in the SQL logs that
> my server is constantly trying to start one database on numerous occasions. I
> must have over 70 entries for this single database. Has anyone experienced
> this problem before?
|||Thank you Tibor and Uri
"Tibor Karaszi" wrote:

> Turn off the autoclose database property. This also hurts performance.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Nick Pennisi" <NickPennisi@.discussions.microsoft.com> wrote in message
> news:1BE05286-4681-4BA8-B9EE-9EA05E376BDB@.microsoft.com...
>
sql