lcaradon (5/10/2016)
We periodically get this message below in the SQL Server log on SQL 2012 Enterprise edition. The database is encrypted using TDE. The encrypted databases on the server were migrated from SQL 2005 and are still set to 2005 compatibility level, we are going to change it to 2012, but have not yet on production.The errors appear usually after a log backup has been saved on one particular database.
SQL Log Message:
An error occurred while processing log encryption. The process was recovered automatically. No user action is required.
Sometimes along with this message is a lock request timeout message but not always.
Lock request time out period exceeded.
Error: 1222, Severity: 16, State: 55.
I understand that it says no action is required, but just curious what is causing this error and is there cause for concern?
Were you able to resolve this?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden