I've found in the past that the Copy Database Wizard can be a little touchy if you have a lot of foreign-key constraints in the database. If the tables aren't created in exactly the right order, some fail to be transferred. It's particularly a problem if you've ended up with vaguely circular references. Detaching and copying the files circumvents that kind of problem entirely.