May 5, 2008 at 11:47 am
Our development server for SQL Server (2000), lost power suddenly (batteries in UPS are bad) and when the server restarted the MSSQLServer service just says "starting" for hours on end. Can't connect to the instance locally or remote. Nothing in the event viewer shows anything happening, CPU is at less than 10%, looked at the sql log with notepad, but the most recent log file (933Kb) won't open. I try to open it and I don't get any response, it acts like it is opening (window stops responding) but never does.
In Service manager and in EM, the service shows as neither stopped nor running and all options to start or stop are disabled.
How can I tell what this is doing ? It looks like it is rebuilding the databases or something.
May 5, 2008 at 12:07 pm
When a SQL database is not shut down nicely, the transactions in process need to roll back when the server comes back up. It is most likely trying to get back to a consistent state.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply