The trouble is, I won't necessarily know the old logical filename. I thought I would be able to read this from the backup header with the QueryResults object returned by .ReadBackupHeader, but I can't see how.
- the original database called dbet08 with logical filenames of dbet08_data, dbet08_log
- backed up to dbet08.bak
- restored to database name et00012308
- backed up to et00012308.bak
In order to restore to a logical name of et00012308 and physical name of et00012308.mdf the relocateFiles option needs to be "[dbet08_data],[c:\data\et00012308.mdf]"
It must be in there somwhere as enterprise manager reads it & displays it in the backup dialog.