Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Query to get User Database Startup DateTime when SQL Server Started Expand / Collapse
Posted Wednesday, February 12, 2014 7:54 AM


Group: General Forum Members
Last Login: Monday, October 17, 2016 3:06 AM
Points: 182, Visits: 635
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 .
Post #1540742
Posted Thursday, February 13, 2014 11:26 AM



Group: Administrators
Last Login: Yesterday @ 3:36 PM
Points: 34,362, Visits: 18,572
You can probably modify this to help you and look for "recovery complete". :

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1541348
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse