Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 starting up Database

Author  Topic 

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-01-29 : 00:39:08
hi,
I have a database which is working fine. But the log says that is starting up, I mean it is continuosly starting up.
till now no one has reported any problems, but I can't find out what is wrong with it.

log Entry:


2004-01-29 10:51:40.33 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:41.86 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:44.45 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:44.92 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:45.33 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:45.77 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:46.12 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:46.48 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:46.89 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:47.47 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:47.91 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:48.36 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:48.78 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:49.20 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:49.59 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:49.98 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:50.37 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:50.78 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:51.16 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:51.55 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:51.94 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:52.30 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:52.62 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:52.95 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:53.33 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:53.69 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:54.06 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:54.62 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:55.00 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:55.37 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:55.78 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:56.11 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:56.49 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:56.94 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:57.31 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:57.72 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:58.05 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:58.41 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:58.80 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:59.16 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:59.50 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:51:59.89 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:00.25 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:00.58 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:01.02 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:01.44 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:01.91 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:02.27 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:02.63 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:02.97 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:03.33 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:03.72 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:04.05 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:04.42 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:04.81 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:05.35 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:05.75 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:06.08 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:06.41 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:06.80 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:07.13 spid57 Starting up database 'DatabaseName'.
2004-01-29 10:52:07.46 spid57 Starting up database 'DatabaseName'.
2004-01-29 11:00:27.39 spid69 Starting up database 'DatabaseName'.
2004-01-29 11:07:41.98 spid69 Starting up database 'DatabaseName'.

thanks in advance
harsh.

He is a fool for five minutes who asks , but who does not ask remains a fool for life!

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2004-01-29 : 06:00:07
got it.
auto close option was checked.


He is a fool for five minutes who asks , but who does not ask remains a fool for life!
Go to Top of Page
   

- Advertisement -