Azure SQL可读副本不再更新 [英] Azure SQL Readable Replica No Longer Updating

问题描述

I am using geo-replication of a S3 database in US East to a S0 database in US West.

在我进行测试的过去一周中，它一直运行良好.昨天，我在主数据库上进行了大型索引重建操作，这使DTU负载最大，大约需要8-9小时.从那时起(我不确定)，我的辅助服务器不再更新. 我大约在24小时前删除了主数据库中的表格行，但该行仍显示在辅助数据库中.辅助服务器不显示任何DTU负载. Azure门户将辅助状态显示为可读".

This has been working fine for the past week while I have been testing it. Yesterday I did an large index rebuild operation on the primary which maxed DTU load for about 8-9 hours. What seems like since then (I can't be sure), my secondary is no longer updating. I deleted a table row in the primary around 24 hours ago now and it still shows in the secondary. The secondary does not show any DTU load. Azure portal shows the secondary status as "Readable".

为什么我的辅助数据库不再更新?

Why is my secondary no longer updating?

推荐答案

Kspearrin，

Hi Kspearrin,

次要对象是否偶然处于只读模式?

Is the secondary in Read-Only mode by chance? 

如何在Azure地理复制数据库中更新统计信息和重建索引

谢谢

迈克

这篇关于Azure SQL可读副本不再更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！