Copy Database wizard fails but leaves no text file log I've been using the copy database wizard to create a development copy of my database.

Unfortunately, the copy database wizard has repeatedly failed.  I suspect the problem is that the sql server agent service account does not have the necessary permissions.  I can't verify this because the log file isn't actually being saved.  I've tried having it save to the default directory where I know the account running the copy database operations must have permissions and to another location on the server.

Any thoughts about how I can resolve this problem?  The new database is showing up but without any tables...
Please use backup / restore. The copy database wizard is a disappointing sack of, well, let's leave it at that.