Symptoms

Assume that you have a database that has transparent data encryption (TDE) enabled in Microsoft SQL Server 2008 or SQL Server 2008 R2, any write operation against the database waits indefinitely on WRITELOG or LOGBUFFER.

When the database is in full recovery mode and scheduled log backups are being done regularly, the first and last log sequence number (LSN) numbers in SQL Server error logs are same for consequent log backups after the issue is hit. It is still advised to confirm if any user activity is expected during this timeframe. The LSN numbers may not change because there is no write operation caused by the lack of user activity. Related SQL Server error log entries are following:

Log was backed up. Database: <DataBaseName>, creation date(time): <Date><Time>, first LSN: 76383:11154:1, last LSN: 76383:11154:1….. This is an informational message only. No user action is required.
Log was backed up. Database: <DataBaseName>, creation date(time): <Date><Time>, first LSN: 76383:11154:1, last LSN: 76383:11154:1….. This is an informational message only. No user action is required.

This issue is not specific to database in full recovery mode, databases with other recovery modes are also prone to encounter the same issue. Additionally, you may also see a SPID in rollback state in system table sys.sysprocesses.

Cause

This issue occurs because of some underlying exception around TDE.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×