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

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

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

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

GO
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