November 16, 2011 at 9:45 am
I want to know SQL Restore operation start time and End time so how i can know ?
Any Script to know that ?
November 16, 2011 at 9:55 am
Do you mean while you are restoring or do you mean a historical record?
The only thing I'm aware of is what is in msdb.dbo.restorehistory and it does NOT have a start and end time, just a restore date.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 16, 2011 at 9:59 am
for Historical Restore Operations
November 16, 2011 at 10:39 am
Then like I said all I'm aware of is msdb.dbo.restorehistory which does not give you exactly what you want, but it does tell you when you are had a restore occur. If you really want to know start time and stop time you'd have to put that kind of logging code into your restore process.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 16, 2011 at 10:42 am
Check the default trace. If it didn't roll over that'll give you the start time for sure.
Then in sql logs you'll have the time it comes online.
(Sorry don't know what info is missing in that table, never used it ;-)).
November 16, 2011 at 10:48 am
I just had to take a peep.
restore_date gives you the start time of the restore. Without end time nor lenght it's not really useful. You could always backtrace it to the job that runs it to the time needed.
If you have log restores, you could always take that is the end restore date. That would be close enough if your logs are small. Again using the rest of the history you could make a decent guess at it.
November 16, 2011 at 10:56 am
Nvm, That shows the original backup start and end times from the original backup.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply