SQL Instance Last restart date and time in SQL Server

Introduction:

When your SQL instance was last restarted?

I understand it is very simple script but we often forget  simple scripts. Hence I thought to write this simple script and also we can use GUI to find the same. Both the ways I have described below.  Using GUI it is very easy and simple and additionally you will get some more information such as SQL edition, collation, number of databases including system.

Script:

Screen Shot:

SQL Instance last restart time
SQL Instance last restart time

Using GUI:

Step 1. Connect to SQL instance using SSMS.

Step 2. Right click on SQL instance –> Select Reports –> Standard Reports –> then click on Server Dashboard

Screen Shot:

SQL Instance last restart time
SQL Instance last restart time

Facebook Comments Box
Please like or share this post if you found it helpful, thank you.
Share on Facebook
Facebook
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Email this to someone
email
Print this page
Print

Comments

Leave a Reply

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