Sql-2000 database keeps 'starting up' 2

[jsteph]

I have a database in my sql-2000 server, which as far as I know is not used anymore. This box had a lot of old unused dev db's which haven't been taken offline or removed, this is apparently one of them. But I noticed in the sql logs, that there are times when it starts dozens of times per minute.

For example, as I scroll through the logs, I'll see:
"Starting up database 'Kang'" numerous times in a row--sometimes as much as 25 within a minute, sometimes just 2 or 3. This is at all times througout the day--no specific time seems to be a common denominator.

Does anyone know what might cause this? As far as I know, none of our developers use this, the lastest object create date is over 4 years ago, and I can find no datetime-timestamp field with any data newer than that either.
Thanks,
--Jim

 

[fuzzyocelot]

I've run into this before as well. See if the AutoClose option is set to True. If so, try changing the AutoClose option to false and see if that fixes it.

 

[mrdenny]

Fuzzyocelot is correct. The AutoClose option is enabled.

What's happening is that someone keeps logging into the database and then disconnecting. Each time this happens the database is spun back up, and when the last session ends the database is spun back down. So if you have a single thread opening and closing connections over and over again you end up with the database starting over and over.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[jsteph]

Yes, the autoclose was on, thank you both very much!
--Jim

 

[fuzzyocelot]

You are very welcome!