Sys.databases column log_resuse_wait value is 4, but dbcc opentran shows no active open transactions

[CrazyPotato]

My os is Windows server 2019

My Sql Server is Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) 

My database recovery mode is simple

When I run select * from sys.databases, my database log_reuse_wait value is 4,

When I run dbcc loginfo, one entry shows status equals to 2

But When I run dbcc opentran, it shows No active open transactions.

Please help me, how to fix this, thank you

[#2]

Please try to set the recovery model of the database FULL. After that change it back to SIMPLE again.

[#3]

Hi,

To get more information about DBCC command with in-depth knowledge, refer below website.

https://madesimplemssql.com/category/dbcc/