Error log: Starting Database (LOTS of log entries)

Posted on 2007-10-01
Last Modified: 2008-02-26
Hi all,

I have about 10 databases running at the same SQL Server 2000 instance. Everything works ok but I just had a look at the SQL Server error log and it really have a lot of lines like:

2007-10-02 06:38:48.35 spid72    Starting up database 'FileSend'.

When I say a LOT I really mean it..... like 1 per second or something like that!!!

Now, everything works..... even the filesend database and there are no other messages in the error log....
Should I worry or? I think i should right? ithis is not normal, but where do I start looking?

Thx a lot!
Question by:nicolajsb
    LVL 142

    Accepted Solution

    every database is initially (on start up of sql server) started up explicitely. just to check if everything is fine.

    now, if that continues through the day, then check if the mentionned databases are configured to "auto-close" (you can find that in the database properties). if they are, uncheck that setting.

    that property will make sql server "close" the database if it has not been used for a certain while, and flush all it's data from the memory.
    that does indeed free up memory, but in case the databases are still quite frequently used, it just kills the performance.

    Author Comment

    LOL Thx a lot :-)

    This is about the most stupid thing I have ever seen...... MUST mention that the DB was configured by a developer and not me ;-)
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    well, it's not a stupid option, per se, it has it's validity.
    In practice, however, I have not see this in prod servers, only in test and dev servers...

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now