SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Moving data using replication

buchananm avatar
buchananm
19 diapositives · 231 Views · Jan 05, 2020

Learn how to move and replicate data efficiently between servers using various replication types such as snapshot, transactional, merge, and peer-to-peer. Understand the key terminologies, setup process, potential issues, and troubleshooting methods in database replication.

Moving data using replication - slide 1
01 / 19Moving data using replication
1 / 17

Télécharger la présentation

Moving data using replication
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Moving data using replication Anthony Brown anthony@found-it.net http://www.sqlblogcasts.com/blogs/antxxxx

  2. What can you do with it • Move data and data changes from one server to another • Filter data by columns or rows • Can be configured so data changes happen on any server and are replicated back

  3. Why replicate • Get data nearer the users • Reporting • Scale out

  4. Types of replication • Snapshot • Transactional • Merge • Peer to peer

  5. Terminology • Publisher – generates data to be sent out • Subscriber(s) • ultimate receiver of data • Distributor • stores data to be sent to subscribers

  6. Terminology • Article • database object to be replicated • Publication • Collection of articles in a database • Push/Pull subscriptions • Determines whether the data is pushed or pulled from distributor

  7. Snapshot replication • Reads data from publisher and stores it at distributor • Loaded into subscriber • No special setup needed for table

  8. Transactional replication • Normally runs snapshot replication first • Any data changes are read from transaction log and stored at distributor • Changes are sent in sequence to subscribers • Tables must have primary key • With special setup can have updates on subscribers

  9. Merge replication • Can be used where data updated at publisher and subscriber • Table must have a guid column • Subscribers can be occasionally connected

  10. Peer to peer replication • Allows data to be updated on all nodes • Configured on top of transactional replication • Typically distribution server is on each node • Only in enterprise

  11. Setup • Can be done using wizard in management studio or T-SQL scripts • Create linked servers first • Can script creation scripts once created by wizard – either management studio or RMO (powershell)

  12. Transaction log • Logreader reads the transaction log • Will not be marked as free until transactions read by logreader • But will still be backed up and can be restored

  13. Database mirroring • Can be used on publisher, not distributor or subscriber • Data not replicated until it is sent to mirror (can be changed with trace flag 1448)

  14. What can go wrong • Security (normally problem at setup) • Connectivity between servers – recovers automatically when they are back • Timeouts • Data becomes out of sync between publisher and subscriber – use validate subscriptions to check this • Fix by re-sync or data updates (tablediff)

  15. Troubleshooting • Check replication monitor • Check event log • Tracer tokens • Sp_browsereplcmds (carefully) • profiler