Forum Discussion
CrazyPotato
Nov 14, 2022Copper Contributor
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...
Nov 22, 2022
Please try to set the recovery model of the database FULL. After that change it back to SIMPLE again.