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

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...
>

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...
> >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'
>

number of errorlogs in mssql 7.0

hi,
Is there any setting in mssql 7.0 to change the number of
sqlserver error logs from the default value of 6?
I know for sure - we can change a registry setting for
mssql2000. IS there anything for mssql7.0?
regards,
bharathbharath wrote:
> hi,
> Is there any setting in mssql 7.0 to change the number of
> sqlserver error logs from the default value of 6?
> I know for sure - we can change a registry setting for
> mssql2000. IS there anything for mssql7.0?
> regards,
> bharath
You need to change the registry entry:
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQ
LServer
DWORD NumErrorLogs = <xx>
(answered previously by Neil Pike, MVP)
http://groups.google.pl/groups?hl=p...&rnu
m=4
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.sql