DataSentinel

DataSentinel

Friday, January 11, 2013

Replication & AlwaysOn Availability Groups

Replication supports the following features on Availability groups:

A publication database can be part of an availability group. The publisher instances must share a common distributor. Transaction, merge, and snapshot replication are supported.

In an AlwaysOn Availability Group an AlwaysOn secondary cannot be a publisher. Republishing is not supported when replication is combined with AlwaysOn.

Four new stored procedures provide replication support for AlwaysOn.

· sp_redirect_publisher (Transact-SQL)
· sp_get_redirected_publisher (Transact-SQL)
· sp_validate_redirected_publisher (Transact-SQL)
· sp_validate_replica_hosts_as_publishers (Transact-SQL)

No comments: