Many times I must look into sys.databases to determine the last SQL Server service restart. The fastest way to do that is just look at your tempdb create date:
SELECT * FROM sys.databases
--or
SELECT create_date FROM sys.databases WHERE [name] = 'tempdb'
But, today I need to know when the Windows server was rebooted. Very easy, and I wanted to share it with you. Open up a cmd prompt and type 'net statistics server'.
Voila! See the 'Statistics since 10/18/2018 1:03:54 PM' -- that is your last server boot time.
Happy SQL Servering!
No comments:
Post a Comment