An interesting topic in SQL Server,
Is it possible to find the last restarted datatime of a server?
When my server is started is the question?
OOPS... where this data is stored. Frankly speaking even I dont know. But, I found a work around to achieve the same.
SQL Server is holding a database named 'tempdb' which gets flushed off during server down or server stop and created once sql server is restarted. So, we can fetch the relative data from tempdb's created date.
Below is the query to fetch this information,
SELECT create_date FROM sys.databases WHERE [name]='tempdb'
Happy Learning!!!
Regards,
Venkatesan Prabu .J
No comments:
Post a Comment