Determine who restarted SQL Server?

• DataDave

  SSC Eights!

  Points: 919

  More actions

  January 14, 2011 at 3:35 am

  #233285

  Hi, in my SQL server error log I see that SQL Server has been stopped and restarted:

  SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.

  How can I determine who did this? I don't see any thing in eventvwr security relating to a user (apart from logoff notifications).

  I am running SQL Server 2008 Ent on Win2K8.

  Thanks in advance.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  January 14, 2011 at 6:54 am

  #1273511

  Isn't it possible it was a self restart?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP