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...
> >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'
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment