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.
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center