'Starting up ' message in db's

  • I have a lot of this kind of messages in a SQL2000 Server, what can i do? is this wrong?

    Thanks in advance

  • You most likely have the Auto Close option set on your databases. Open EM and right click each DB and select properties. It will be found in the bottom section of the options tab. Remove the check and apply. This is better to do as subsequent operations do not have to wait for the DB to be placed in start to execute against them. Make sure model does not have turned on as well since all DBs defaults are built around models.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply