>Hi
>
>I'm having a problem restoring a database
>
>I've amended some data in a database to set up a testing scenario and then backed up that database.
>
>I'm now trying to create a copy of the test data by creating a new empty database and restoring from the backup into it.
>
>When I try to restore (in managment studio) I am selecting Overwrite the existing database (With Replace).
>
>But I still get the message
>
>The backup set holds a backup of a database other than the existing ''test_x' database.
>RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154)
>
>any ideas what I could be doing wrong .
>
>Thanks

Try scripting the restore operation and post the generated script for inspection. May be the error will be clearer.