Cannot restore database from backup

[Guest_imported]

I am trying to restore a database on a new server from a backup taken on another server. I am running on SQL Server 7.0. When I do this through Enterprise Manager, I get the error:

The file "...new DB file_name.mdf" cannot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file. Backup or restore operation terminating abnormally.

Am I incorrect in assuming that I should be able to restore a database onto a new server? Any suggestions would be appreciated.

 

[aalmeida]

On EM Select The Dabase you want to restore,
then Select Restore Db, select the Backup file or device,
Select the Tab Options and put a check mark where it says: "Force Restore Over Existing database", also make sure the "Restore As" have the correct path where the db files should reside.
This should work for you. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"