Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My sql error log is full of messages telling me one or another of my dbs is starting up - sometimes the time spacing is only fractions of a sec apart:

2010-08-27 10:07:00.98 spid59      Starting up database 'myDb'.
2010-08-27 10:07:03.11 spid59      Starting up database 'myDb'.
2010-08-27 10:07:03.44 spid59      Starting up database 'myDb'.

I'm seeing this on several db that have very low activity and on seeing any on thoes dbs that are more active. No intervening messages saying anything about an error condition - is this normal?

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

Take a look at the properties of your database. If "AutoClose" is on the database will shut down after the last connection is closed.

It is recommended to set Autoclose to false.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.