Quote Originally Posted by Oops_my_bad View Post
If the FMS database doesnt attach and produces that error, close dbattach on the new server and open it again. Detach the FMS database (probably ccsfms) and re-attach it. Should work fine the second time (same thing sometimes happens with the SIMS database too)
I had another look at this yesterday and managed to sort it in the end by running simssqlapplication.exe again.