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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center