How to find out the last shutdown time by SQL Server?

• YTZ

  SSCommitted

  Points: 1707

  More actions

  September 28, 2010 at 12:54 pm

  #227406

  I don't mean the last start time by,

  SELECT create_date

  FROM sys.databases

  WHERE database_id = 2

  I need the last SHUTDOWN time.

  Thanks.

• ben.rosato

  SSCommitted

  Points: 1929

  More actions

  September 28, 2010 at 1:01 pm

  #1228620

  Look at the first archived sql log file

• YTZ

  SSCommitted

  Points: 1707

  More actions

  September 28, 2010 at 1:10 pm

  #1228625

  Ben:

  Could you explain the details please?

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  September 28, 2010 at 1:26 pm

  #1228633

  Under the Management folder in SSMS, there is an error log folder. Look at the prior error log (errorlog.1) to determine when the shutdown was issued.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 28, 2010 at 1:31 pm

  #1228637

  T-SQL alternative to what Steve had mentioned. Execute

  sp_readerrorlog 1

  The last entry in the output would give you the time when the instance was restarted

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga