Bill,

You have to force the restore over the existing database. If you are using EM to do the restore, on the options tab it is one of the top checkboxes. Also, make sure you specify the correct path and filename to the database that you are restoring into.

I do this all the time. Much faster than DTS.

BOb


>Hi Mike,
>>This is really easy as long as the source and target servers are both using the same character set and sort order, unless the target server is SQL Server 2000.
>>
>>The hands-down easiest is to make a backup and restore it on the new server. Next, would be detaching the database using sp_detachdb and reattaching it to the new server using sp_attachdb.
>>
>>If the two servers are using different character sets and/or sort orders, us the DTS Object Transfer.
>
>I know this is an old thread, but...
>I am using SQL7. I did a backup on one server (Tools/Backup Database...) to a disk file. Then I tried to do a restore on the other server (Tools/Restore Database...) Since the database didn't already exist, I created an empty one. I get a error that says the backup set isn't for this database.
>Did I have to create all the empty tables, etc.? I was hoping the Restore could do that for me.
>TIA,