DBCCSQLPERF(LOGSPACE)GOSELECTname,recovery_model_desc,log_reuse_wait,log_reuse_wait_descFROMsys.databasesGO 可以看到log_reuse_wait_desc 为REPLICATION 在该库下执行DBCC loginfo(),可以看到该数据库的所有VLF的状态都为2,也就是active状态。 DBCCloginfo() --- 网上找到一篇钊吉兄的解决方法: sp_removedb...
一天那个哥们看到数据库日志暴涨,用sys.databases 视图看一下[log_reuse_wait_desc]为replication,但是数据库根本无做replication 但是数据库有做CDC 数据抽取,最后发现原来是CDC的问题,导致收缩日志失败,把CDC停掉,问题解决 因为CDC跟replication都是使用同一个log reader线程,sys.databases里的log_reuse_wait_desc只会...
We have done the following. And we still cannot shrink the log and the log_reuse_wait_desc still reads REPLICATION. I told taking the database out of the AAG is not an option and changing the recovery mode to SIMPLE is also not an option. What else can we try? BACKUP LOG[ldm_c...
DESCRIPTION:The log scan number (5583766:93420:2) passed to log scan in database '<database name here>' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurredduring replication,re-create ...
Earlier this week I had multiple engagements of Comprehensive Database Performance Health Check. While working with one of the customers we realized that when we query sys.databases for one of the databases, we always see column log_reuse_wait_desc conta
--- log_reuse_wait_desc = Replication --- 2. Force removal of the replication. EXEC sp_removedbreplication MyDatabaseName --- 3. Check SELECT name, log_reuse_wait_desc FROM sys.databases --- check if MyDatabaseName says --- log_reuse_wait_desc = Nothing ...
log_reuse_wait_desc为REPLICATION,日志暴大,无法收缩 早上检查数据发现,有一台数据的硬盘空间只剩下几MB。习惯性检查日志文件,发现日志文件居然暴增到了350多GB 首先备份日志,再收缩---无变化。(实际上日志备份每1小时1挡,正常在跑.) --- 检查日志空间占用及不能截断原因: DBCCSQLPERF(LOGSPACE)GOSELECTname,...
log_reuse_wait_desc为REPLICATION,日志暴大,无法收缩 早上检查数据发现,有一台数据的硬盘空间只剩下几MB。习惯性检查日志文件,发现日志文件居然暴增到了350多GB 首先备份日志,再收缩---无变化。(实际上日志备份每1小时1挡,正常在跑.) --- 检查日志空间占用及不能截断原因: DBCCSQLPERF(LOGSPACE)GOSELECTname,...
I tried removing the replication using "EXEC sp_removedbreplication" but it did not work. In fact I never had replication enabled, althugh there was a plan to do so over the previous weekend. unless some guy in the team tried to set it up and did not clean up properly. He shouldnt be...
log_reuse_wait_desc为REPLICATION,日志暴大,无法收缩 早上检查数据发现,有一台数据的硬盘空间只剩下几MB。习惯性检查日志文件,发现日志文件居然暴增到了350多GB 首先备份日志,再收缩---无变化。(实际上日志备份每1小时1挡,正常在跑.) --- 检查日志空间占用及不能截断原因: DBCCSQLPERF(LOGSPACE)GOSELECTname,...