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?