Is filtering possible in Microsoft SQL AlwaysOn?

Question

Hi All, 

Is it possible to exclude certain tables to be replicated/synchronized by AlwaysOn?

Thanks.

Answer 1

Hi,

It's possible, all actions you doing in principal, is mirrored to replicas.

See:

Overview of AlwaysOn Availability Groups (SQL Server)

---

Se a resposta foi útil por favor classifique. Tiago Neves - @tiagolneves - acesse o meu blog http://www.tiagoneves.net

Answer 2

Hello,

AlwaysOn works with complete database(s), not with single objects like in Replication.

See Overview of AlwaysOn Availability Groups (SQL Server)

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

Hi All, 

Is it possible to exclude certain tables to be replicated/synchronized by AlwaysOn?

Thanks.

Why are you mixing replication with Availability Groups in AOAG the whole database is synchronized with secondary replica not just single table while in replication a single table can be replicated

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Wiki Articles
MVP