Thank this author by sharing:
This script shows the COMPLETION datetime of database restore.
Restore using "with standby " takes too long to complete
Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database
31 Days of Disaster ...
I am familiar with the various queries that can be run to return information out of the 'msdb' datab...
SQL 2008 DB flagged as "Restoring" for 1 day and counting...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.