Post reply

Starting up database XXXXX.

  • March 16, 2004 at 10:17 am

    #84641

    I happend to be reviewing SQL Server logs and noticed that "Starting up database 'XXXXXX'. " where the XXXX refers to the database name, appears every single day ranging from 10-50 times every say 30 seconds. I don't see anything in the log that would trigger this, but it seems to happen at random times.

    1. Do you know what is causing thing?

    2. Is this something to be concerned with?

     

    Thanks

  • March 16, 2004 at 10:40 am

    #498995

    Check that autoclose is not set.

    http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp

  • March 16, 2004 at 11:06 am

    #499007

    I think Steve has probably nailed the issue.  However, it could also be a process that is taking the database offline or even detaching and reattaching it.  Hopefully, you would know about such a process!

    To answer your second question, yes it is something to be concerned with, you should definitely work to resolved it.

    Regards,

    Steve


    Regards,
    Steve

    Meddle not in the affairs of dragons, for you are crunchy and taste good with ketchup.

  • March 17, 2004 at 12:46 am

    #499076

    Thanks, Autoclose was the problem.

     

    Burt

Viewing 4 posts - 1 through 3 (of 3 total)

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