Restoring Encrypted Backups

Application issues
1

We are currently in the evaluation and testing stage of FTPBackupandFTP.

Our SQL server has encryption enabled, and as such all our databases are encypted.

Backups work without any problems, however when attempting to restore the test database, this error is occurring.

10/2/2024 4:00:45 PM [Error] Failed to restore “RESTFC” database. T-SQL command error: ALTER DATABASE [RESTFC] SET ENCRYPTION ON

Cannot change database encryption state because no database encryption key is set.
ALTER DATABASE statement failed.

Please can you offer some assistance?

Thanks

2

Hello,

Thank you for your message.

Please try removing the following line from the backup file (it will be at the beginning):

ALTER DATABASE [RESTFC] SET ENCRYPTION ON

Afterward, restore the backup, then manually create the database encryption key and enable encryption.

We plan to improve this aspect of our application in future releases.

Regards,
Oleg