Backup and Restore the Database using Encryption

Message

Executed as user: Domain\ServiceAccount. Cannot find server certificate with thumbprint '0x62A3B87C122C170DFEEBFC6AFCB14B4E5BB5543B'. [SQLSTATE 42000] (Error 33111) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Backup the certificate with master key on the Primary Server

BACKUP CERTIFICATE [EncryptionCertificate]

TO FILE = 'Certificate File path'

WITH PRIVATE KEY (FILE = 'Master Key File path.dat', ENCRYPTION BY PASSWORD = 'password')

Restore the certificate with master key password on the Secondary Server

CREATE CERTIFICATE [EncryptionCertificate]

FROM FILE='Certificate File path'

WITH PRIVATE KEY ( FILE = 'Master Key File path.dat' , DECRYPTION BY PASSWORD = 'password')

This will resolve the issue and can restore the database with out any errors.