• Another suggestion or two:

    Think about the future, after the initial backup/restore, detach/attach; updating production can be tricky. Make plans on how changes will be performed to production. (approval process, logical steps, physical steps, etc.) "If you fail to plan, then you plan to fail." Trust me on this, spend some time thinking and documenting this.

    In addition, get a third party tool that can compare two databases (security settings, users, structure, etc. etc.); and can generate scripts that will get the databases in sync. Since many production database are directly related to the bottom line ($$$), it should be easy to justify the expense.

    $0.02