Copy Database Wizard fails in the last step. The Database on the destination server is dropped and then fails. While setting up Copy Database Wizard there is a screen which asks for File share name. The File share location appears automatically. Is the File share name the name of the database that is to be copied to the destination server.
@ Jassi.....I went through the link you had posted. When I run the Copy Database Wizard I get an additional screen which displays the Shared link folder and asks for Shared File. This screen is not mentioned in the link you had posted. What is the name of the Shared File it is asking for?