As I have documented this problem for myself I am attaching the description as a word document which has screenshots.
I am copying underlying data files for sqlserver from development to production and I am getting the security errors in the document.
There is a fix for the problem as noted in the Word doc but as I have to refresh the data often I really do not want to have to run the fix every time I copy underlying files (from DATA directory) over.
Note. I always copy the .mdf as well as the .ldf.