Sorry to break the threay i started earlier but once again I need this to work and I have spent al day on it with no luck.

SCOPE:
I need to copy my database from my sql server 7 platform to another office on
another server that also has sql 7. DTS will not work for me due to network traffic and so forth I would get messages saying that it failed. i tried it off/ peak time but still the same.
Now in the days of 6.5 I would be able to creat a new db device for LOAD then I would copy the dump over there and run LOAD database blab blah .. No brainer.

I have tried the following ideas some of you have mentioned such as back up the db (I would zip it copy it over there ) unzip it and tried to RESTORE it but I get the following: "The backup set holds a backup of a database other
than the existing 'mydb' database. Backup or restore operation terminiating abnormally."

I would also try restoring from FILE and I would get the similar message.
Sp_attach and detach no good either.

What am I missing. i would create a new 'mydb' then try the restore all of the above is all I get...