Problem restoring a backup of a database in SQL Server 7

Hi,

I was trying to move a database from one SQL server to another, so I went into Enterprise Manager and chose to backup the Database that I wish to move. The database that I am moving has never existed on the new SQL server that I want it to now reside on.

I copied the backup of the database into the directory, mssql7\backup and I then went into Enterprise Manager, and chose restore database. I chose restore by device, then select device, then add. In the field 'File Name' from the window 'Choose Restore Destination' I just gave the location of the backup file mssql7\backup\dbname and hit ok until the 'Restore Database' window.

If I then click view details of the device, it does not list the backed up database in the window. I will add that the database backup file has no file extension, and some of the backups from my own SQL server have the extension .BAK, but renaming the backup file that I am trying to put on this server has no effect.

Has anyone experienced similar problems trying to move a SQL database from one server to another? And if so do they know how to fix it? I have played around with it a lot and checked the help files etc but they just describe the process that I am performing.

Any help will be much appreciated, and thanks for reading!

Go into the new enterprise manager and create that database, reflecting the same database "location" BEFORE you run the restore. Check the box on the options tab that states FORCE RESTORE.

Hope this works.