地理复制已停止从主数据库复制 [英] geo-replication stopped copying from primary

问题描述

我的地理复制中的辅助数据库刚刚停止更新。我可以访问服务器和数据库，但数据没有更新为主

The secondary DB in my geo-replication just stopped updating. I can access to the server and the DB but the data is not updated as the primary

推荐答案

你好Victor，

Hi Victor,

如果您导航到Azure门户并查看此（主）数据库的Geo-Replication刀片，复制是否显示为已配置且处于活动状态？应该有一个辅助列表...这只是为了查看配置是否存在。 

If you navigate to the Azure Portal and view the Geo-Replication blade for this (primary) database, does replication show as being configured and active? There should be a list of secondaries...this is just to see if the configuration is present. 

您可以在主数据库上运行以下T-SQL：

Could you run the following T-SQL on the primary database:

SELECT   
     link_guid  
   , partner_server  
   , last_replication  
   , replication_lag_sec   
FROM sys.dm_geo_replication_link_status;

sys.dm_geo_replication_link_status（Azure SQL数据库）

您可以使用以下内容查找特定数据库的当前作业（将"myddb"更改为主要或辅助以查找与任一数据库相关的复制作业）：

You can use the following to look for current jobs for a specific database (change 'myddb' to the primary or the secondary to look for replication jobs related to either database):

SELECT * FROM sys.dm_ operation_status   
   WHERE major_resource_id = 'myddb'   
   ORDER BY start_time DESC;

sys.dm_operation_status（Azure SQL数据库）

因此，如果我们发现配置存在，然后验证是否有任何复制作业正在运行或上次运行，我们就可以开始弄清楚发生了什么。 

So, if we figure out that the configuration exists and then verify if there are any replication jobs running or last time they ran, we can start to figure out what is going on. 

谢谢，

迈克

这篇关于地理复制已停止从主数据库复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！