SQL可读副本不再更新

SQL可读副本不再更新

本文介绍了Azure SQL可读副本不再更新的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在使用美国东部的S3数据库到美国西部的S0数据库进行地理复制.

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?

推荐答案

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

Is the secondary in Read-Only mode by chance? 

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

谢谢

迈克


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

09-05 06:02