I've never had luck detaching db's from prod & copying them to dev/qa &
maintaining full content/functinoality....something always stops working in
dev/qa.
The process I use to move prod to dev/qa is to use CA to do a backup of the site
collection & DB to a file share from prod. Then in qa, go into the site
collection & remove the db. Then run a restore from the location where you made
a backup of prod. At the end of the restore, sharepoint should attach to the
db, but most of the time, I have to do it manually.
If you have problems at that point, then it's all about permissions of the
default content access account and the rights it has to the db on the SQL server
(happens most often when your user account doesn't have SA & local administrator
permissions on the SQL server).
This method is more along the lines of a DR type of restore, but it works every
time.
Standard disclaimer applies... your mileage/results will vary since no two
installations are identical.