August 25, 2003 at 6:42 am
Why do I see "Starting up database xxxxxxx" about 25 times between 10:59AM to 11:05AM.
Is this behavor normal?
My customer says that it seems to occur in backup situations.
//Patrick
August 25, 2003 at 9:20 am
August 26, 2003 at 12:10 am
The AutoClose is shut off. Is it possible that it caused the problem?
//Patrick
August 26, 2003 at 7:59 am
It sure sounds like autoclose is on. Did you import this database from access or MSDE? Autoclose will get set to on comming from these sources sometimes.
Wes
August 26, 2003 at 8:03 am
You might want to check the scripts you have running around that time...maybe a script is causing the database connection to close.
-SQLBill
August 26, 2003 at 10:29 am
Hi All,
We just checked one of my colleague's DEV Database Server Log for "Starting up database xxxxxxx" yesterday. We have restarted the SQL Server (7.0). As soon as we restarted, within few mins, we could see "Starting up database xxxxxxx" few times.
Didn't know why its happening. It should not be caused by Auto Close.
What else can cause this?
.
August 26, 2003 at 11:52 am
What do you mean by:
It should not be caused by Auto Close
That IS the message seen when Auto Close is set to ON for a database.
If Auto Close is set for off, check your SQL Server error logs and the Windows Event logs. You might find other indications of problems. Something might be stopping the services.
-SQLBill
August 26, 2003 at 1:32 pm
I am sorry about that. I take back my word. I meant that "in my case Auto Close might not causing the problem."
When I looked at my colloegue's database server, I looked at wrong option (auto shirnk) thinking that its "auto close". Thats the reason for my above statement.
.
August 26, 2003 at 2:43 pm
I have been in touch with my customer and they are sure that AutoClose is off, because they put it in off state. But interesting enough is that efter the AutoClose was set to off, the problem disappeared.
Thanks all for the rapid help
//Patrick
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply