I tried to restore database from a backup file copied from other server.
I use enterprise manager to restore the database with force overwrite existing.
I want to change the data files to another location, meaning in the backup file it is E:\sql\data, Now I would like to change it to F:\data. so in the option tab, I changed the directory to F:\data, but right after I click to run the restore database, it gives error: file cannot be restored to..., use with move to identify a valid location.
Does this mean I cannot use EM to restore a database to a path different from what is in bak file.