database copy wizard HELP

I have been using SQL Server 2000 but not am not an expert on it. I recently
copied databases into a new server using Database Copy Wizard. The previous
databases were copied with no problems. This problem occured when I selected
5 databases at the same time although I doubt the # of databases had anything
to do with the problem. It still copied into the new server but the
databases on the "source" server disappeared! I tried "re-copying" same
databases back into the source server but I am getting a 'name conflict'
error. From my research, this meant the mdf and ldf files are still there.
Note that I "copied" and NOT "moved" these databases. Can you please tell me
how I can restore these databases? I also tried re-creating the missing
database so I can export data back into it but I got "Error 5170: Cannot
create file 'e:\data\MSSQL\...\.MDF' because it already exists. etc" Thank
you for helping.
--
_________________
Freedom is nothing else but a chance to be better. (Albert Camus)Hi
Right click on databases in Enterprise Manager, All Tasks,
Attach. Browse for the *.mdf. If it's there, it will re-
attach it. The DB copy wizard detaches the DB, copies it
and then reattaches it. You said you selected Copy and not
Move so I guess something went wrong and it didn't re-
attach it as a final step.
Regards
Jono|||You are correct. Thank you very much!
"Jono" wrote:
> Hi
> Right click on databases in Enterprise Manager, All Tasks,
> Attach. Browse for the *.mdf. If it's there, it will re-
> attach it. The DB copy wizard detaches the DB, copies it
> and then reattaches it. You said you selected Copy and not
> Move so I guess something went wrong and it didn't re-
> attach it as a final step.
> Regards
> Jono
>