Forum Discussion

CrazyPotato's avatar
CrazyPotato
Copper Contributor
Nov 14, 2022

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

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 Replies

  • dkgdba's avatar
    dkgdba
    Copper Contributor
    Mar 17, 2024
    Hi,

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

    https://madesimplemssql.com/category/dbcc/
  • AlbertoMorillo's avatar
    AlbertoMorillo
    MCT
    Nov 22, 2022
    Please try to set the recovery model of the database FULL. After that change it back to SIMPLE again.

Resources