Tag Archives: Temp DB Started Time

How to Find SQL Server Started date & Time – 4 Scripts to Find SQL Server Started Time

There  are so many way of finding the sql server started date time.

1. SQL Server Log

2.  using DMV

3. Using TempDB Creation date (as it is recreated when SQL Server is started every time)

4. Start Time of Default Trace

Examples : 

1. SQL Server Log :

SQL Server Management Studio –> Management –> SQL Server Logs –> We need to Search for the “SQL SERVER Starting….Image


 sp_readerrorlog 0,1,’Copyright (c)’




2. Using DMV :

SELECT sqlserver_start_time FROM sys.dm_os_sys_info;


3. Using TempDb Creation Date

select crdate from sys.sysdatabases where name=’tempdb’

4. Default Trace :


SELECT login_time FROM sys.dm_exec_sessions WHERE session_id = 1;