Home Dashboard Directory Help
Search

Record SQL Restart events in a system table by Ranga1


Status: 

Closed
 as External Help for as External


1
0
Sign in
to vote
Type: Suggestion
ID: 776712
Opened: 1/16/2013 8:04:07 AM
Access Restriction: Public
0
Workaround(s)
view

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 ?
Details
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!
Sign in to post a workaround.