Record SQL Restart events in a system table by Ranga1

Resolved

as External Help for as External

Type:	Suggestion
ID:	776712
Opened:	1/16/2013 8:04:07 AM
Access Restriction:	Public

Workaround(s)

view

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 (expand)

English

SQL Engine

Basically, record all sql service shutdowns in a audit table for review. A table in master db would help, also, if this feature is not needed, we can have a trace flag that can enable this feature.

Improved Security

Helps find the reason when sql restarts "mysteriously". Another feature that will enhance SQL server's usability/likabilty.

0 attachments

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!

Microsoft