How to identify the SQL Server Start/Restart Date & Time ?

 Posted by PandianS on 10/27/2010 | Category: Sql Server Interview questions | Views: 3402 | Points: 40

1. When was the SQL Server Service Started ?
SELECT sqlserver_start_time 'SQL Server Started at' FROM sys.dm_os_sys_info

2. When was the TempDB database Re-Created ?
SELECT create_date 'SQL Server Started at' FROM sys.databases WHERE [name] ='tempdb'

Both the query have some difference on it's Time, Because, The Tempdb database will be Re-created after the SQL Server service started.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response