Help using copy database wizard

I am trying to copy a database from one sql server 2005 to another. I am a sysadmin on both servers. I first tried copying the same database on the same server using the wizard and it worked :). However when I tried copying it to a different server, Execute SQL Server Agent Job fails. Unfortunately, I don't know the exact error; the error message ought to have been logged to windows event log, however after I open the event viewer, I can't find any error whatsoever logged to application. I tried having the error logged to a local directory as a text file and after the error occured, I still cannot find the error log :(
The difference between copying a database from the same server to copying on different servers is the "Location of Source Database Files", included in the wizard. I am not sure what to place in the field "File share on source server". Do I need to create a file share folder? Where can I have information on how and why it is necessary?
Thanks for taking your time to help me.

Candy

The online or local help for Copy Database Wizard goes into more detail, but I can give a couple of possible tips:

1. Remote job event logs or files will show up on the destination server machine not the machine running CDW (if they are different machines). Look in the WIndows event log on that machine, or in the file system there if you redirected error output logging to a file.

2. Location of Source Database Files refers to the path to the .mdf/.ldf files of the source datatase as seen from the destination machine. Usually in the form of a net share path of the form \\machine\share\... which you share out to get at the data files for the database you want to copy. CDW will invoke a job on the destination machine under either your domain account or some proxy account (depending on how you indicate it) which will use the file share path you gave it in the wizard to try to access the source machine's database data and log files. Share security permissions are also material just like you were trying to map the source machine share and copy the files yourself using Windows Explorer on the destination machine.

Hope that helps, and the online or local help can give some more details on what I summarized above.

|||What is the service pack level on both SQL Server instances?|||I am running service pack 2 on the source machine and service pack 1 on the destination machine.|||

Best way to solve look microsoft online help issue about SQL server 2005

Thanks

Faiz Farazi

www.databasetimes.net

Best learning center for Microsoft

http://www.lascomp.com