In SQL server, How to see the standby file path when we restore the database in standby mode:

  I was answering to the questions on Social.msdn.microsoft.com forum site, Someone posted the question :  How to see the standby file path when we restore the database in standby mode:  I checked lots of DMVs e.g. msdb..restorefile, msdb..restorehistory etc. but couldn’t find any place to get the standby file name. I Spent around 1-2 hours…

1