SQL Server – Check Last Restart Date and Time of SQL Server

  By ,

To check the date and time SQL Server last restarted, execute the T-SQL script below.

 

SELECT​​ sqlserver_start_time​​ FROM​​ sys.dm_os_sys_info

 

 

 

 

 

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL Server – Get VLF Counts for All Databases in an Instance
  2. SQL Server – Resolve Error 5030 to Rename Database
  3. SQL Server – Get Index Creation Date
  4. SQL Server – TSQL Script to Check Job Run Status
Tagged  , , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *