Copy databases

Hi,
Maybe a stupid question, but I'm trying to copy some databases from one server to another. The copy databases wizard says the job is successful and I can see that the job has been done on the remote server. But the copied databases are not there. What do I do?
Anyone?|||Make sure you connected (during the copy) to the right (the same as you have inspected later)instance of SQL Server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||How do you know if the databases are not there? do select * from sys.databases and see if they are there.|||Aren't they supposed to show up in the database tree in Object explorer? I can't see them...only the ones that I exported, but copying is supposed to be a better method.
|||

they are but you need to refresh the tree, by running the query I asked you to I was asking to check if they were really there.

Are the databases you are looking for in the resultset from the query I asked you to run?

|||I did and no they are not there.
|||Hmmm very strange, my only suggestion is to try again and look for errors.|||'Execute SQL Server Agent job' generates an error and the log says 'Login failed for user'.
|||So I think some Agent debugging might be in order then to make sure it is working ok, Management Tools Group folks can help, then come back.sqlsql