copy database error

running into a problem trying to copy a database from one machine to another.
Here is what I have
source machine
database name is database1
and it uses files named
test and
test_log
in the data folder(created automatically by SQL2000).
Destination machine has a database on it called
database2 but it uses files named
test and
test_log
in the corresponding data folder also.
I want copy database1 over to the machine that has database2 in it, without
damaging database2, but since they are using the same named files I get an
error message when I try a restore from device on the destination machine
using a backup file created on the source machine for database1. Also
specifiying the restore to database1 name does not seem to help.
Can I change the names of the files used by database2 on the destination
machine and will it cause any problems(database2 is used by a few .net web
applications).
thanks.
--
Paul G
Software engineer.Problem has been solved, just changed file location on restore.
--
Paul G
Software engineer.
"Paul" wrote:
> running into a problem trying to copy a database from one machine to another.
> Here is what I have
> source machine
> database name is database1
> and it uses files named
> test and
> test_log
> in the data folder(created automatically by SQL2000).
> Destination machine has a database on it called
> database2 but it uses files named
> test and
> test_log
> in the corresponding data folder also.
> I want copy database1 over to the machine that has database2 in it, without
> damaging database2, but since they are using the same named files I get an
> error message when I try a restore from device on the destination machine
> using a backup file created on the source machine for database1. Also
> specifiying the restore to database1 name does not seem to help.
> Can I change the names of the files used by database2 on the destination
> machine and will it cause any problems(database2 is used by a few .net web
> applications).
> thanks.
> --
> Paul G
> Software engineer.