New answers tagged

0

Here are the answers to each of your question 1 How the copying of binary log works? I wrote a detailed list of the steps taken by MySQL Replication in my answer to Is MySQL Replication Affected by a High-Latency Interconnect?. Someone else answered that same post, but from the point of view of DB Client 2 Is it first writes to master binary log ...


1

To research this, I configured transactional replication on my test server with 1 article having row filter. I did this for Adventureworks.Sales.Store table having [CustomerID] <10. Initially, I tried querying distribution..sysarticles to check the filter details. But, surprisingly it did not show any data in it. Then I checked ...


2

There are locks taken on the subscriber during data transfer which can cause blocking on the subscriber - so you can definitely encounter issues there (and there are options to modify this behaviour at the risk of not being able to rollback failed transactions). However there aren't any other magical locks or connections between the servers. But also ...


-1

The problem was with delete operations sequence. Problem solved.


1

for several hours you will be fine, one of the conditions for a log reuse is whether or not all of the records in the VLF have been processed by the log reader. Keep the log reader running, find out and stop the distributor agent job for each of the publications affected by the distributor server going down, before you switch the distributor server off. I ...


2

SQL won't clear transactions from the log that the log reader hasn't marked as done (Committed to Distribution). So your log may grow while the Distribution server is down, but once it comes back, the log reader should be able to catch up over time. From BOL: The Log Reader Agent runs at the Distributor; it typically runs continuously, but can also run ...


0

We ended up coming up with a solution for this. Basically, we had to manage the partition creation for both the publisher and subscriber databases/tables when we made a change. We were loading data using SSIS and there were mechanics that were built in to create new partitions on the publisher, so we implemented the same logic to do the work on the ...



Top 50 recent answers are included