-
タイトル
Restore Transparent Data Encryption (TDE) LiteSpeed Backup fails with code 995 -
説明
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.
-
原因
Encryption key is being recreated incorrectly, therefore restoring an un-decryptable certificate. -
対策
Source Instance
- 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
- Drop the incorrectly formed certificate:
DROP CERTIFICATE Bad_Certificate
- 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.