© 2022 Hashnode
#replication
Nie przepadam za Azurem. Z perspektywy programisty wiele rzeczy nie działa tam tak jak powinno, a narzędzia, które powinny być dostępne out-of-the-box wymagają żmudnej konfiguracji i kombinowania. Dla…
If you ever answer yes to any of the below, you might have ended on right article. Tired of TL;DR feeling going through huge articles with ton of information? Ever miss out important information due …
Master Slave/DB replication As the name suggests, master-slave is a concept where there is one master and multiple slaves. The concept of master slave is also known as DB replication. Replication means having a copy or replicating something…
Problem: I have configured the distributor and then trying to create a publication on the publication server using sp_addpublication stored procedures with respective parameters. I have got the below error message. Error message: Msg 14013…
To find out the list of replicated transaction, query the MSrepl_transactions table in distribution database. Copy the sequence number of the transaction (i.e., xact_seqno ) which entered the distribution database last. SELECT top 1 entry…
Replication Replication Monitor SELECT publisher, publisher_db, publication_id, CASE publication_type WHEN 0 then '0 - Transactional publication' WHEN 1 then '1 - Snapshot publication' WHEN 2 then '2 - Merge publication' END AS …
If you are adding a subscription using "initialize with LSN" option when the log reader agent is stopped, the auto generated stored procs will not be generated. You can use the below script to generate it. This script will generate the belo…