Restore Transparent Data Encryption (TDE) LiteSpeed Backup fails with code 995 (4224959)

When restoring a LiteSpeed backup of an encrypted database by executing T-SQL that opens the master key and executes stored procedure master.dbo.xp_restore_database with move on a SQL instance that is not the backup source, the execution fails with the following error:

LiteSpeed® for SQL Server® Version 8.9.8.56 (64bit) Copyright 2023 Quest Software Inc. ALL RIGHTS RESERVED.

Msg 61700, Level 16, State 1, Line 0RESTORE DATABASE is terminating abnormally.
Read on "" failed: 995(The I/O operation has been aborted because of either a thread exit or an application request.)
Please create a master key in the database or open the master key in the session before performing this operation.
 

*Note* a SQL Server native backup file restores successfully.

Source Instance
 

1. Backup the certificate used to encrypt the database:

BACKUP CERTIFICATE Good_Certificate
TO FILE = 'C:\Backup\APXCAW19S1901_APXCAS02-20240710\Good_Certificate'
WITH PRIVATE KEY (file='C:\Backup\APXCAW19S1901_APXCAS02-20240710\Good_CertificateKey.pvk',
ENCRYPTION BY PASSWORD='yourpassword')

Target Instance
 

1. Drop the incorrectly formed certificate:

   DROP CERTIFICATE Bad_Certificate

2. Create certificate from file:

   CREATE CERTIFICATE Good_Certificate
   FROM FILE = 'C:\Backup\APXCAW19S1901_APXCAS02-20240710\Good_Certificate'
   WITH PRIVATE KEY (FILE = 'C:\Backup\APXCAW19S1901_APXCAS02-20240710\Good_CertificateKey.pvk',
   DECRYPTION BY PASSWORD = 'yourpassword' )

Restore command is now successful.