无法停止复制-数据库X的终止操作已在进行中 [英] Cannot stop replication - A terminate operation is already in progress for database X

问题描述

由于我的副本数据库未更新的问题(请参阅

Due to an issue of my replica database not updating (see here), I am now trying to delete the secondary database and just start over again. However, whenever I tried to "Stop replication" from the portal I am now receiving the following error:

停止复制错误

推荐答案

sys.dm_operation_status动态管理视图所说的是什么?先前尝试停止复制的状态是什么?

SELECT * FROM sys.dm_ operation_status

What the sys.dm_operation_status dynamic management view says? What is the status of previous attempt to stop replication?

SELECT * FROM sys.dm_ operation_status  

   ORDER BY start_time DESC;

Alberto Morillo
SQLCoffee.com

这篇关于无法停止复制-数据库X的终止操作已在进行中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！