Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    1

    Unanswered: who can tell me what's mean of my db logfile?

    In my database named aa ,there are always some words like this:


    2004-05-12 09:44:48.96 spid73 Starting up database 'aa'
    2004-05-12 09:44:49.17 spid73 Starting up database 'aa'
    2004-05-12 09:44:49.36 spid73 Starting up database 'aa'
    2004-05-12 09:44:49.56 spid73 Starting up database 'aa'
    2004-05-12 09:44:53.37 spid79 Starting up database 'aa'
    2004-05-12 10:02:41.96 spid73 Starting up database 'aa'.
    2004-05-12 10:02:42.24 spid73 Starting up database 'aa'.
    2004-05-12 10:02:43.61 spid73 Starting up database 'aa'.
    2004-05-12 10:02:43.80 spid73 Starting up database 'aa'.
    2004-05-12 10:02:44.02 spid73 Starting up database 'aa'.
    2004-05-12 10:02:44.24 spid73 Starting up database 'aa'.
    2004-05-12 10:36:42.84 spid82 Starting up database 'aa'.

    who can tell me how to resolve this problem?

  2. #2
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Most probably the Auto close option is set for this database.
    uncheck 'Auto Close' from properties of this database, that should solve the problem.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Or use from query analyzer:
    SP_DBOPTION 'DBNAME','AUTO_CLOSE',false

    and its not suggested to enable AUTO CLOSE on produciton database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •