Linked Questions

Popular Questions

I have the latest version of OLA Hallagrens backup script.The code being ran is:

EXECUTE [Master].[dbo].[DatabaseBackup] @Databases = 'MyUser_DB', @Directory = N'\\SFTPIPAdress\Backups', @BackupType = 'FULL', @Verify = 'N', @CleanupTime = 720, @CheckSum = 'Y', @FileName = '{DatabaseName}_{Year}{Month}{Day}_{FileNumber}.{FileExtension}',@Compress='Y', @Encrypt = 'Y', @EncryptionAlgorithm = 'AES_256', @ServerCertificate = 'DBBackupCertificate', @LogToTable = 'Y'

The error I'm getting is:

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.    
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

This looked like a recent bug.The user was able to resolve their issue by adding the log to table param which I'm already making use of. Not sure where to go from here or what options I have.

It seems like the existing media set is not encrypted and can't add an encrypted one or the sequence/chain is being broken.

Related Questions