Im building my first transactional replication database for our Sharepoint team. The Publisher database is fairly large 330GB+ Because the Publisher database is in a different data center than the Distributor and Subscriber database I will be perfoming the initial seed using a database backup instead of using a snapshot.
I understand that the Publisher will know the last log sequence number (LSN) from when the backup was taken. The Subscriber will be populated from the back up and have it's own last LSN from the restore.
Im not sure how the process will work once I turn the synchronization on after everything has been initialized/restored.
- Does the Publisher talk to the Subscriber through the Distributor to know how far out of sync they are? I thought the Publisher and Subscriber did not have any real direct communication?
- How will the proper records be sent to the Distributor from the Publisher when the Distributor is unaware of the initialization from backup.
Publisher: SQL Server 2008 R2
Distributor: SQL Server 2012
Subscriber: Sql Server 2012