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.
Vous devez être connecté et disposer d'un contrat de maintenance en cours pour afficher les articles de la base de connaissances avancés.
© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center