• You could potentially change to partial containment to solve the tempdb issues, if this is SQL 2012+.

    We're in the 2008 forum, but posts sometimes are incorrectly posted.

    However, that's a great point. If your new server has a different collation, tempdb will, and that will cause issues.