Post reply

Starting database Message from SQL log

  • February 24, 2003 at 5:15 pm

    #58337

    I have a lot messages in the SQL log like this

    2003-02-24 09:17:47.84 spid53Starting up database 'boveda'.

    2003-02-24 09:17:48.07 spid53Starting up database 'boveda'.

    2003-02-24 09:17:48.29 spid53Starting up database 'boveda'.

    2003-02-24 09:17:48.51 spid53Starting up database 'boveda'.

    2003-02-24 09:17:48.76 spid53Starting up database 'boveda'.

    2003-02-24 09:17:49.15 spid53Starting up database 'boveda'.

    2003-02-24 09:20:12.43 spid53Starting up database 'boveda'.

    2003-02-24 09:20:16.26 spid53Starting up database 'boveda'.

    2003-02-24 09:20:16.48 spid53Starting up database 'boveda'.

    2003-02-24 09:20:16.68 spid53Starting up database 'boveda'.

    2003-02-24 09:20:16.90 spid53Starting up database 'boveda'.

    2003-02-24 09:20:17.12 spid53Starting up database 'boveda'.

    2003-02-24 09:20:17.56 spid53Starting up database 'boveda'.

    2003-02-24 09:22:32.15 spid60Starting up database 'boveda'.

    2003-02-24 09:28:58.39 spid56Starting up database 'boveda'.

    Some one knows why????

    What can be the reason for that message?

  • February 24, 2003 at 5:25 pm

    #449663

    I'm wondering if these are related to your database closing when no one is using it. If this is the case, it would open whenever someone needed to use it. Have you looked at the "AUTO_CLOSE" option for your database. If it is 'ON' you might want to try to turn it 'OFF'.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • February 26, 2003 at 11:09 am

    #449791

    Thanx Greg, you are rigth

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

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