SQL Server Error Msg 3467 – Restore was successful but deferred transactions remain. These transactions cannot be resolved because there are data or keys in the enclave that is unavailable. For keys, since there is no enclave configured, SQL may resolve deferred transactions by invalidating indexes on encrypted columns; please check the error log.For the data, either use RESTORE to make that data available or drop the filegroups if you never need this data again. Dropping the filegroup results in a defunct filegroup.

In this blog post, let’s learn about the error message “3467 – Restore was successful but deferred transactions remain. These transactions cannot be resolved because there are data or keys in the enclave that is unavailable. For keys, since there is no enclave configured, SQL may resolve deferred transactions by invalidating indexes on encrypted columns; please check the error log.For the data, either use RESTORE to make that data available or drop the filegroups if you never need this data again. Dropping the filegroup results in a defunct filegroup.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

3467 – Restore was successful but deferred transactions remain. These transactions cannot be resolved because there are data or keys in the enclave that is unavailable. For keys, since there is no enclave configured, SQL may resolve deferred transactions by invalidating indexes on encrypted columns; please check the error log.For the data, either use RESTORE to make that data available or drop the filegroups if you never need this data again. Dropping the filegroup results in a defunct filegroup.

Reason for the Error

To be update soon…

Solution

To be update soon…