Nov 13 2022 10:44 PM
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
Nov 22 2022 11:42 AM
Mar 17 2024 04:30 AM