![]() It ignores other changes captured in the Transactional Logs and copies data changes from the Transactional Log to the Distribution database. The Log Reader Agent scans the Transactional Log of the Publisher database to detect the tracked changes marked for Replication. The Full Backup is supported via T-SQL statements only. The Snapshot Agent can perform the Initialization via the Replication Configuration Wizard. SQL Server Transactional Replication can be initialized from the Publisher to Distributor and then to the Subscriber database via Snapshot Agent or Full Backups. Once the Articles are enabled for Replication, any changes happening on these articles will be marked for Replication in the Transactional Logs of Publisher database. In the Publisher Database, create a Publication comprising the list of Articles ( Tables, Views, etc.,) that you need to replicate to the Subscriber database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |