Dumb question, have you physically copied the mdf/ldf files to the new location after running the t-sql code and taking the database offline?