After writing this post, I copied the db to another server of ours which was also release 6.5.2 then deleted the origanal db and then copied it back to the origanal location and all was ok again.
When I tried doing the same thing to my local machine this did not work…
Any ideas to why it is now ok would be appreciated.