Query to get User Database Startup DateTime when SQL Server Started

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  February 12, 2014 at 7:54 am

  #304316

  Hi

  I would like to find Query to retrieve User DataBase Startup Time from SQL server that we see in the Sql Server Log ,Can some one help me in finding the it . Thanks In advance

  I was able to find the Server Startup Time but not the individual Databases .

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  February 13, 2014 at 11:26 am

  #1688872

  You can probably modify this to help you and look for "recovery complete". :http://timlaqua.com/2009/09/determining-how-long-a-database-will-be-in-recovery-sql-server-2008/

  The problem is that SQL Server doesn't log individual database times. It logs the start of recovery, and if it takes time, it will get the percentage of effort underway, but I'm not sure that there's a way to get the time it completes for any particular db. At least in a couple instances I have, I don't see the recovery complete time.