Post reply

Query to get User Database Startup DateTime when SQL Server Started

  • 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 .

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply