One of the easiest way to find when SQL server was restarted is using Dynamic Management view (DMV).
In some of the scenarios we need to know when the SQL server was restarted.
DMV
SELECT * FROM SYS.DM_OS_SYS_INFO
Example
I have taken the Sqlserver_start_time column from the above view.
So now my SQL server instance restarted time is 2017-02-08.
No comments:
Post a Comment