February 28, 2018 at 1:14 pm
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!
February 28, 2018 at 2:24 pm
cidr - Wednesday, February 28, 2018 1:14 PMHi,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 errorSystem.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
March 1, 2018 at 1:37 am
Sue_H - Wednesday, February 28, 2018 2:24 PMcidr - Wednesday, February 28, 2018 1:14 PMHi,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 errorSystem.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
Thanks Sue. Will creating a new media set not delete the old media set?
March 1, 2018 at 1:56 am
cidr - Thursday, March 1, 2018 1:37 AMSue_H - Wednesday, February 28, 2018 2:24 PMIt'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
Thanks Sue. Will creating a new media set not delete the old media set?
What command are you using to do the backup?
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply