Why does the message Starting up database xyz keep showing up in my SQL log file

• Carl Uman

  SSCommitted

  Points: 1993

  More actions

  June 26, 2006 at 10:06 am

  #173284

  Any ideas on why this would be happening?  Sometimes it does it w/o the Analysis line and repeats the starting line only.  None of the other DBs on the server are doing this.  It has been doing this for over a month.  Some days more than others.

  2006-06-20 14:52:34.49  spid380 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:52:26.10  spid380 Starting up database 'ProLawTest'.

  2006-06-20 14:32:48.03  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:32:47.49  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:32:47.10  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:32:46.73  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:32:46.45  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:32:45.96  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:32:45.70  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:32:45.07  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:32:44.71  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:32:44.15  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:32:43.84  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:32:43.38  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:31:49.68  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:31:49.09  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:31:48.54  spid271 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:31:44.76  spid271 Starting up database 'ProLawTest'.

  2006-06-20 14:24:07.22  spid302 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:24:06.99  spid302 Starting up database 'ProLawTest'.

  2006-06-20 14:22:52.91  spid370 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:22:52.68  spid370 Starting up database 'ProLawTest'.

  2006-06-20 14:18:23.32  spid265 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:18:22.65  spid265 Starting up database 'ProLawTest'.

  2006-06-20 14:15:09.67  spid297 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 14:14:39.39  spid297 Starting up database 'ProLawTest'.

  2006-06-20 13:28:15.44  spid306 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:15.22  spid306 Starting up database 'ProLawTest'.

  2006-06-20 13:28:10.69  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:10.49  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:28:10.22  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:09.83  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:28:09.49  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:09.26  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:28:09.01  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:08.79  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:28:08.55  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:08.32  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:28:08.07  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:07.80  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:28:03.37  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:03.15  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:28:02.82  spid103 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:28:02.58  spid103 Starting up database 'ProLawTest'.

  2006-06-20 13:21:10.42  spid311 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:21:10.20  spid311 Starting up database 'ProLawTest'.

  2006-06-20 13:21:09.62  spid311 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:21:09.37  spid311 Starting up database 'ProLawTest'.

  2006-06-20 13:12:16.49  spid202 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 13:12:13.82  spid202 Starting up database 'ProLawTest'.

  2006-06-20 09:39:34.57  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 09:39:34.21  spid94 Starting up database 'ProLawTest'.

  2006-06-20 09:39:33.94  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 09:39:33.69  spid94 Starting up database 'ProLawTest'.

  2006-06-20 09:39:33.41  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 09:39:33.18  spid94 Starting up database 'ProLawTest'.

  2006-06-20 09:39:32.71  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 09:39:32.33  spid94 Starting up database 'ProLawTest'.

  2006-06-20 09:39:32.05  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 09:39:31.80  spid94 Starting up database 'ProLawTest'.

  2006-06-20 09:39:31.46  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 09:39:29.27  spid94 Starting up database 'ProLawTest'.

  2006-06-20 08:45:33.97  spid197 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 08:45:32.02  spid197 Starting up database 'ProLawTest'.

  2006-06-20 07:29:58.45  spid68 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:58.23  spid68 Starting up database 'ProLawTest'.

  2006-06-20 07:29:57.97  spid68 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:57.72  spid68 Starting up database 'ProLawTest'.

  2006-06-20 07:29:57.45  spid68 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:57.23  spid68 Starting up database 'ProLawTest'.

  2006-06-20 07:29:55.20  spid68 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:54.98  spid68 Starting up database 'ProLawTest'.

  2006-06-20 07:29:44.15  spid95 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:43.92  spid95 Starting up database 'ProLawTest'.

  2006-06-20 07:29:39.92  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:39.68  spid94 Starting up database 'ProLawTest'.

  2006-06-20 07:29:39.42  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:39.18  spid94 Starting up database 'ProLawTest'.

  2006-06-20 07:29:38.95  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:38.73  spid94 Starting up database 'ProLawTest'.

  2006-06-20 07:29:38.50  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:38.29  spid94 Starting up database 'ProLawTest'.

  2006-06-20 07:29:38.04  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:37.82  spid94 Starting up database 'ProLawTest'.

  2006-06-20 07:29:37.53  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:37.29  spid94 Starting up database 'ProLawTest'.

  2006-06-20 07:29:34.56  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:34.32  spid94 Starting up database 'ProLawTest'.

  2006-06-20 07:29:33.92  spid94 Analysis of database 'ProLawTest' (22) is 100% complete (approximately 0 more s

  2006-06-20 07:29:31.98  spid94 Starting up database 'ProLawTest'.

• Philip Yale-193937

  SSCarpal Tunnel

  Points: 4603

  More actions

  June 26, 2006 at 10:11 am

  #645874

  Check the properties of the database, under the "Options" tab. I think you'll find the "AutoClose" box is checked. Personally, I'd uncheck it - it should stop your warning messages.

• Carl Uman

  SSCommitted

  Points: 1993

  More actions

  June 26, 2006 at 11:14 am

  #645883

  It was checked. I corrected ALL the settings to what they should have been

  Thanks a bunch

  Carl

• Carl Uman

  SSCommitted

  Points: 1993

  More actions

  June 28, 2006 at 7:13 am

  #646346

  Just a follow up to say that seemed to fix it.  Thanks again.

• Janaki-382435

  Valued Member

  Points: 54

  More actions

  November 14, 2006 at 12:01 am

  #671504

  Hey,

  How to disable Auto-Close in Sql MSDE?

   

  -JL

• Janaki-382435

  Valued Member

  Points: 54

  More actions

  November 14, 2006 at 2:47 am

  #671536

  Got it... mine was of 2005 version so i installed sql server management studio to connect to it and change its  properties...

   

  -Janaki

• Balmukund

  SSCertifiable

  Points: 6648

  More actions

  November 14, 2006 at 5:29 am

  #671575

  sp_dboption 'autoclose' ,'false'