Hi,
I have 2 database A and B on SQL Server 2005 Express. From both databases I
have a backup.
Now I want to use the backup B.bak to restore it to database A. The problem
is when i do so the logical filename and physical filenames of the .mdf and
.ldf of database A are overwritten with the filenames in the backupset i.e.
from database B.
How can I keep the logical and physical filename of database A when I
restore database A from a backup of database B using SMO.
When using SSMS you can modify the logical and physical filenames prior to
the execution of the restore. So the same should be possible using SMO, but I
don't know how.
Thanks