Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Wednesday, February 12, 2014 7:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:06 PM
Points: 163, Visits: 573
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 .
Post #1540742
Posted Thursday, February 13, 2014 11:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:20 PM
Points: 33,078, Visits: 15,192
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.










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