HI experts, this is a strange one.
The db is old archived data and the attributes the data file show "Compress
contents to save space". Also the db is read-only
I need to move the db to another server:
I tried detaching it and attaching the files on the target server. Got Error:
"The ... mdf file is compressed but does not reside in a read-only database or file group. The file must be decompressed."
SO I tried backing up the source db and restoring on the target.
Got error: Cannot open database ABC version 782. Upgrade to the latest version".
Tried to remove the read-only attribute on the source db.
Got error : "AlLter db failed. The ... mdf file is compressed but does not reside in a read-only database or file group. The file must be decompressed."
Has anyone faced this issue?
Thanks