Log message - Starting up database 'DATABASE NAME'. 1

[Robhunter999]

I am repeatedly seeing the message "Starting up database 'DATABASE NAME'" in the SQL log files for some of the databases. This makes the log files very difficult to check the logs accurately and makes them very large.

This line tends to occur in batches of three or four, and all hours of day and night, but only affects some of the databases.

I am looking to establish if this is a problem with the SQL Database setup, or the code written as the front end (Delphi), and what i can do to eliminate the unnecesary entries

Any help appreciated.

Rob Hunter

 

[tlbroadbent]

Those databases probably have the autoclose option set to TRUE. When the option is True, SQL closes the database when not in use. It then reopens the DB when needed. Thus you see many Starting... messages. Use sp_dboption to set the option to false.

exec sp_dboption 'db_name','autoclose','False' Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[Robhunter999]

Thanks a lot for that, the problem seems to be caused by the Delphi apps that grab chnks of data and then let the database Autoclose, causing the entry each time the next request is sent.

Turning this off has meant the logs are so much easier to monitor.

Thanks again
Rob Hunter