SQL Server Unexpectedly stopped

Question

Post reply

SQL Server Unexpectedly stopped

TST1

SSCommitted

Points: 1798
More actions
January 4, 2010 at 8:24 am

#215187

Hi,
My sql server unexpectedly stopped. I couldn't find anything in sql error logs, and I have checked event viewer and nothing too descriptive apart from sql server successfully stopped.
Any thoughts of what else I need to check?
Server is sql 2000
Thanks

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

John.Sansom SSCertifiable Points: 7335 More actions · Answer 1

Hi,

Have you reviewed the Windows Event Logs?

For example, do you have automatic Windows updates enabled and if so perhaps this caused a server reboot.

Reviewing your Windows Event Logs may provide you with more insight.

John Sansom (@sqlBrit) | www.johnsansom.com

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 2

In agreement with John.

What do you see in the other Windows event logs that correspond to the time frame of the stop messages? The events showing within Windows Event logs should give you a username that caused the service to stop, generally.

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

What's the last three entries in the SQL error log?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 4

To add to earlier replies, have you checked if Windows has rebooted at that time?

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

TST1 SSCommitted Points: 1798 More actions · Answer 5

Hi,

Thanks for all your replies. I have checked event logs and I couldn't find anything conclusive. In the application area, I found that sql server agent service successfully stopped but there is nothing more on this. Under the system event, another entry with sqlserver agent service entered the stopped service.

With regards to windows update, this is not set up to run automatically.

Under Sql Error logs I could only find error [360] sql serveragent initiating a shutdown following mssqlserver shutdown, then error [359] local host server is not running and then sqlserveragent terminated (normally)

TST1 SSCommitted Points: 1798 More actions · Answer 6

Gail,

Sorry the last 3 entries were

1) [360] Sql server agent initiating shutdown following mssqlserver shutdown

2) [359] Local host server is not running

3) [098] sql server agent terminated (normally)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

That doesn't look like the SQL Server error log. It looks like the SQL Agent log, which is not going to gove anything useful regarding teh SQL service itself.

I'm asking for the last few lines from the SQL Server error log (file name ERRORLOG), accessible through management studio from Object explorer. Management-> SQL Server Logs

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

TST1 SSCommitted Points: 1798 More actions · Answer 8

Gail,

The time at which the issue happened looking at the event viewer doesn't seem to make any sense to me.

The last few lines are

recovery of database MNR is complete

recovery is checkpointing database

sql global counter collection task is created

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

That's the SQL startup routine.

The error log has the latest events at the beginning and the oldest at the end.

Just after it stops, look for the file ERRORLOG.1 That will have, at the end of the file, the reason that SQL shut down. There should be something like 'SQL Server is stopping due to ..... ' That's want we're looking for.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

TST1 SSCommitted Points: 1798 More actions · Answer 10

Hi Gail,

I've had a look at the logs and there isn't much. Trawling through the windows logs as well it seems that sql could have been accidentally stopped by someone and I'm trying to see how this can be proven!

Is there a way I can monitor why sql server was stopped and by who for future reference.

Thanks

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 11

if you want to, you can attach the errorlog file to your reply (if it is not to big) so we can have a look

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 12

One suggestion - try cross referencing the time of the SQL Server service shutdown from the application event log to the Security event log - maybe that will get you closer to who might have stopped things.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."