• As an update we went ahead with the detach/attach, as this is what the DB programmer suggested in the end for convenience.

    I am still puzzled as to why people are against this method, well I suppose if the DB is in production it causes more room for error than a backup/restore. Since this DB is fairly new and not utilized this didn't pose a problem.

    Thanks everyone for your help!