September 18, 2003 at 10:01 pm
Hi,
I have one database that won't finish starting up. The message 'XXX is starting up' keeps showing up in the SQL event log. What is the problem? Thanks.
September 18, 2003 at 11:39 pm
Hi there
Please email the exacte messages in the log.
Also, what does the database show up as in EM?
Run this query and post the results:
select name, dbid, mode,status,status2
from master..sysdatabases
Your db in the result set btw?
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 19, 2003 at 6:27 am
Use Enterprise Manager, drill down to the database, right click on the database, select Properties, go to the Options tab.
Is Auto-Close checked or unchecked?
It should be UNCHECKED.
If it's checked, then everytime a connection completes, the database closes. Which means it has to be started for every new connection.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply