Post reply

Log Files

  • July 17, 2002 at 8:59 am

    #158433

    I was looking at the log files and it said Starting Database ABC. Can someone let me know what does this mean ?

    Thanks

  • July 17, 2002 at 9:45 am

    #432893

    It meant SQL Server was opening the database files for database ABC and getting it ready for use. Typically all databases are marked in this manner when the SQL Server service is started. For instance, here is an excerpt from my logs:

    

    2002-07-16 21:58:38.38 spid3     Starting up database 'master'.

    2002-07-16 21:58:44.96 server    Using 'SSNETLIB.DLL' version '8.0.532'.

    2002-07-16 21:58:44.96 spid5     Starting up database 'model'.

    2002-07-16 21:58:45.14 spid3     Server name is 'MySQLServer'.

    2002-07-16 21:58:45.48 spid8     Starting up database 'msdb'.

    2002-07-16 21:58:45.48 spid9     Starting up database 'pubs'.

    2002-07-16 21:58:45.63 spid10    Starting up database 'Northwind'.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • July 17, 2002 at 10:12 am

    #432899

    I agree with that. We have over 100 databases on a cluster. We are using SQL Server 2000 under Advanced Server 2000. The services have not been restarted for almost a month. And still it shows every day for only a couple of databases that Starting Database "ABC".

    The database is running fine.

    Thanks for any help.

  • July 17, 2002 at 11:28 am

    #432912

    The only other time I have ever seens this is when restoring a database from backup or attaching a db. If this occurrs regularly at specific times then run Profiler to trace for restarts of the server or restores you may not know about.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • July 17, 2002 at 11:32 pm

    #432959

    Are they usually the same databases?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • July 18, 2002 at 1:30 am

    #432967

    Hi, did you check the auto_close option ?

    Klaas-Jan

  • July 18, 2002 at 10:28 am

    #433028

    Brian:

    Yes they are the same databases everytime. And yesterday i saw almost 30 such entries between 5:15p.m. and 5:30 p.m.

  • July 18, 2002 at 10:29 am

    #433029

    Klaas :

    I will check that and let you know.

    Thanks

  • July 18, 2002 at 1:47 pm

    #433044

    Thanks a lot Klaas. That was the problem.

    Thanks everybody for your help.

Viewing 9 posts - 1 through 8 (of 8 total)

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