Hello!
All started when Sql server error log shows:
The transaction log for database 'databasename' is full due to 'XTP_CHECKPOINT'.
On database which uses as usually 30GB log file.
The LOG file now is 400GB
After searching during 2 days I found too little information(((
It seems, that I have the same problem like in this link, log is growing.
https://connect.microsoft.com/SQLServer/feedback/details/1021865
Microsoft SQL Server 2014 - 12.0.2456.0
Database in SIMPLE recovery,
DBCC LOGINFO shows many rows with State=2
DBCC OPENTRAN show 0 transactions
SYS.DATABASES.log_reuse_wait_desc = XTP_CHECKPOINT
No replications
In-Memory enabled and used
Manual CHECKPOINT shows the error:
Error: 41315, Severity: 16, Checkpoint operation failed.
Is anybody catches the same errors before?
PS. I have restored Database and can run CHECKPOINT command and shrink database. But in several minutes I can't repeat this again because of the same
CHECKPOINT error.
---------------------------------------
The same not resolved threads:
I can not shrink transaction log , please help me.
https://social.technet.microsoft.com/Forums/en-US/5a1926b7-cef4-4b64-a06f-e1927dedfe71/i-can-not-shrink-transaction-log-please-help-me?forum=sqldatabaseengine and this :
Log not truncating due to xpt_checkpoint
https://social.technet.microsoft.com/Forums/en-US/4914e549-3f7a-4be1-83e2-442e22a07dc2/log-not-truncating-due-to-xptcheckpoint?forum=sqldatabaseengine
- Edited by Artem Osokin 20 hours 24 minutes ago