Error on Restoring DB on another server

[jluost1]

I am trying to copy my database from one server to another server using backup file.

I have created a backup file with the name like "db_backup.bak". I copied this file from development server to production server.

I created a database with the same name on production server and then tried to restore it on that server. Following is the error:

"The backupset holds the data of database other than existing database. Restore operation terminated..."

In my backupset, there are indeed more than 1 databases when I view filegroups. Even though I picked the latest version and backed it up, those filegroups stick in my backup file. (I also tried to restore the backup with a new name, backup the new database and using that backup file still generated the error even though there is only one file in filegroups.)

In this scenario, how do I copy the latest backup version of my database to another server?

 

[bessebo]

We restore our databases from one server to another all the time since we have a test server that we restore to from our production environment. On the Options tab from the Restore Database task where it says Logical Filename you want to make sure that this is the proper logical filename from the database that you are restoring from. Also the Location is the pathname of the .mdf file for your copy-to server. To find out what the logical filename is on your copy-from database just go to your source database, right-click and choose properties. Under where it says FileName this is what you want to enter for the logical file name when you restore to the destination database. Give it a try.

Regards,
Bessebo