SQL Server Performance Forum – Threads Archive

Starting up database …

Why does the database keep starting up all the time ?
Auto-close is set to OFF Snippit from ERRORLOG.1
2004-02-19 11:54:27.45 spid57 Starting up database ‘database001’.
2004-02-19 11:55:42.53 spid55 Starting up database ‘database001’.
2004-02-19 11:55:43.37 spid57 Starting up database ‘database001’.
2004-02-19 11:55:43.49 spid57 Starting up database ‘database001’.
2004-02-19 11:58:23.84 spid57 Starting up database ‘database001’.
2004-02-19 11:58:23.95 spid57 Starting up database ‘database001’.
2004-02-19 12:00:28.89 spid58 Starting up database ‘database001’.
2004-02-19 12:00:29.01 spid58 Starting up database ‘database001’.
2004-02-19 12:00:38.84 spid56 Starting up database ‘database001’.
2004-02-19 12:00:38.95 spid56 Starting up database ‘database001’.
2004-02-19 12:02:39.51 spid58 Starting up database ‘database999’.
2004-02-19 12:02:39.70 spid58 Starting up database ‘database999’.
2004-02-19 12:02:39.82 spid58 Starting up database ‘database999’.
2004-02-19 12:09:42.95 spid55 Starting up database ‘database001’.
2004-02-19 12:09:43.70 spid57 Starting up database ‘database001’.
2004-02-19 12:09:43.81 spid57 Starting up database ‘database001’.
2004-02-19 12:10:09.59 spid55 Starting up database ‘database001’.
2004-02-19 12:10:09.73 spid55 Starting up database ‘database999’.

What SQL and SP do you have?
Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

SQL 2000 sp3a running on Win2k server SP4

Run SP_DBOPTIOn and list what options were set. If you aren’t getting any performance issues with this then ignore the error, refer to SQL error log for any other errors. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

exec sp_dboption ‘database001’ merge publish
trunc. log on chkpt.
torn page detection
ANSI null default
recursive triggers
autoshrink
auto create statistics
auto update statistics

I think is normal log. May be SQL begin starting 001, 009 and show messages until finish.
BTW: In perfomance terms, I suggest to turn off autoshrink and auto update statistics, is better schedule a job in nonworking times.
Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

True, those seems to be a normal settings other than AUTO SHRINK.
Follow as suggested by Luis about shrink. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>