Hi,
We often restore databases into non-production environments, and have some reports and metrics that are run against these databases.
Occasionally, the databases in the non-prod environment will be renamed after they have been restored.
This causes us a few issues because some of the reports use msdb..restorehistory to determine the age of the database (i.e. when it was restored). This table only shows the name that was used when it was restored, and I can't find a way to link to the new name of the db after it's been renamed.
Is there a way to get the restore date of a database if that database has subsequently been renamed?
Thank you
Steve