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.


1
0
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

Description

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
Hi,

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.

Thanks!