Contents
Does transactional replication lock tables?
Produces native-mode bulk copy program output of all tables but does not lock tables during the snapshot. Only supported for transactional publications. The native method will bulk copy the data out of SQL Server, but locks the table until the process is complete.
What do users receive with transactional replication?
Transactional Replication lets you publish and filter individual database objects. Use column filtering to only include critical columns for published tables, further targeting and limiting exactly what is published.
Can we configure replication in simple recovery model?
Yes, you can use the Simple recovery model… the transaction log is only truncated after a checkpoint AND all transaction marked for replication have been processed.
Can a database mirror be used for transactional replication?
Replication supports mirroring the publication database for merge replication and for transactional replication with read-only Subscribers or queued updating Subscribers. Immediate updating Subscribers, Oracle Publishers, Publishers in a peer-to-peer topology, and republishing are not supported.
When to use stored procedures or replication management objects?
When using stored procedures or Replication Management Objects (RMO) to administer replication at the mirror, for cases in which you specify the Publisher name, you must specify the name of the instance on which the database was enabled for replication. To determine the appropriate name, use the function publishingservername.
How does replication monitor work in SQL Server?
Replication Monitor displays Publisher nodes in the object tree for both the principal and the mirror. If the principal is the active server, publication information is displayed only under the principal node in Replication Monitor. If an agent has an error, the error is indicated only on the principal node, not on the mirror node.
What happens if replication is disabled in SQL Server?
If the publication database fails over from the principal to the mirror and the mirroring relationship is subsequently disabled or removed, replication agents will not function against the mirror. If the principal is permanently lost, disable and then reconfigure replication with the mirror specified as the Publisher.