Hi,
I've reviewed articles and forums but don't seem to find a succinct answer to my issue.
I have an encrypted columns on the database and I want to make an independent backup from the backup set.
I'm using the option Copy-only backup but, I'm getting the error
System.Data.SqlClient.SqlError: The backup cannot be performed because 'ENCRYPTION' was requested after the media was formatted with an incompatible structure. To append to this media set, either omit 'ENCRYPTION' or create a new media set by using WITH FORMAT in your BACKUP statement. If you use WITH FORMAT on an existing media set, all its backup sets will be overwritten.
Is there any strait forward documentation to assist in creating the backup?
Thanks!
It's pretty much in the error message. You are trying to append the backup to an existing device, file or whatever you are using and the media set has non-encrypted backups. You can't append encrypted backups to a set of non-encrypted backups. Create a different device, backup to a different file or tape.
You can't do the encrypted backup to the existing media set that has non-encrypted backups.
Sue