Record SQL Restart events in a system table - by Ranga1

Status : 

  External<br /><br />
		This item may be valid but belongs to an external system out of the direct control of this product team.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 776712 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/16/2013 8:04:07 AM
Access Restriction Public


There should be a way to know when sql server was restarted and by who ? If it was a server restart, who restarted the server, if it was sql service restart , who restarted the sql service etc. Right now we have ways to know when sql was restarted, but how to find who did it or how it was restarted ? 
Sign in to post a comment.
Posted by Microsoft on 4/10/2013 at 12:02 PM

Thanks for your feedback. Unfortunately, this is not really something that we can address in SQL Server as OS does not inform the service who has started/stopped it. As such, this is something that would need to be address through Windows logging instead.