User Profile
CrazyPotato
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
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 you635Views0likes2CommentsSQL Server ldf file size keeps increasing, but there are no changes in the mdf file
I encountered strange things, the .ldf file size is increasing 50G in one hour, and in two hours, it increased by 100 G. But the .mdf has no big changes, such as lot of entry writes. Do you experts help me find what kind of reason can trigger such scenario? My database is SQL Server Express edition. My database under simple recovery mode I tried to run DBCC opentran, but found no hanging transaction I tried to run DBCC shrinkfile(db_log, 1), but the log file size didn't shrink3.4KViews0likes1Comment
Groups
Recent Blog Articles
No content to show