Monday, April 11, 2011

How can you find out the sqlserver last restarted date?

SQL Query for sqlserver last restarted date.


Select Answer:

select create_date from sys.databases where name='master'
select create_date from sys.databases where name='tempdb'
select create_date from sys.databases where name='model'
select create_date from sys.databases where name='msdb'