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.
| Author |
Topic |
|
Mujeeb
Starting Member
1 Post |
 Posted - 2009-06-07 : 04:56:00
|
| Hi we had powerfailure last week and mssql is not starting after that.when tried to start MSSQL service it starts and stops immediately...no errors. MSSQL Agent starts without problem |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-06-07 : 07:27:02
|
| Check the SQL error log (it's just a text file, you can open it in notepad). See if there are any useful messages about why the service isn't starting. Start from the end of the error log (most recent event) and read up.--Gail ShawSQL Server MVP |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-08 : 15:10:23
|
| Anything in event viewer? Between the SQL log and event viewer, it should point to what's raising the issue.Terry-- Procrastinate now! |
|
|
|
|
|
|
MSSQL service not starting