THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Replication   (RSS)
  • Transactional replication - how to initialize a subscription from a backup

    Today I had a chance to initialize my scubscription in transactional replication from backup. The database is quite big (120GB) and I thought it I would be better to use this method to start the replication process. Unfortunatelly this is not possible from the replication wizard and you have to change the publication and subscription definition ...
    Posted to Damian Widera (Weblog) by Damian Widera on October 13, 2014
  • Fundamentals of SQL Server 2012 Replication

    From Red-Gate web site you can download, for free (plus a trial of SQL Monitor), the eBook Fundamentals of SQL Server 2012 Replication written by Sebastian Meine (@sqlity). Data replication is traditionally considered a complex feature and generally we get discouraged easily, already during the preparation of the test environment. Why the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on November 13, 2013
  • Merge Replication Stored Procedure Conflict Resolver

    A conflict in merge replication occurs when applying a replicated command to the subscriber and: there is a constraint violation Foreign Key Violation Primary Key Violation there is an error modifying data Data domain violation Missing dependencies (trigger firing referencing missing objects) Security violation (the account the ...
    Posted to Hilary Cotter (Weblog) by HCotter on November 6, 2011
  • Transactional replication and massive data updates

    SQL Server transactional replication has been a rather solid feature and works well for delivering data to reporting servers (among other things) in near real time. That said, it may not work too well when you need to perform massive updates on a published table, for instance, when you need to archive a large amount of data. It can take a long ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 6, 2011
  • Find the distribution agent jobs

    There may be times when you want to look up the job names for a group of distribution agents. For instance, you may want to be able to stop all the distribution agent jobs for a given publication. How do you look them up in a script? A quick web search on finding the distribution agent job name comes back with suggestions similar to the following ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on August 31, 2011
  • Performance impact: implicit type conversions

    Often you see an implicit type conversion or a type mismatch causing a performance issue when it trips up the SQL Server query optimizer. A while back though, I ran into a case where a harmless looking type mismatch caused significant performance degradation when there was no bad plan involved.   So we had a rather straightforward ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 20, 2011
  • Why is it good to be comfortable with multi-threading?

    If you are an application developer, you should find a new job if you can't do multu-threaded programming. What if you are a DBA? Probably not, not to the same extent anyway. Some in our community clearly realize the importance of being able to do things in parallel. Adam Machanic, for instance, has put in a lot of efforts in this area and ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 8, 2011
  • Transactional Replication and WAN links

    We recently worked on a transactional replication setup that involved a very active VLDB and a subscriber being located on a different datacenter. What made it even more interesting is that the WAN link was not particularly fast. In this post, I would like to mention a few of the challenges we faced while and how we got past ...
    Posted to Argenis Fernandez (Weblog) by Argenis on May 31, 2011
  • Virtual Classes

    I have two online classes starting on November 1st that I recorded on the vClass platform. The first is “Introduction to SQL Server Replication” and is a 12 session class on all things replication. Cost is $199……for more information or to register, click here: The second class is ...
    Posted to Eric Johnson (Weblog) by ejohnson2010 on October 26, 2010
  • Distribution latency in transactional replication: Is a volume surge the culprit?

    If you use transactional replication, I have no doubt that from time to time you are asked to explain why there is an increased latency between the publisher and the subscriber. More often than not, this end-to-end latency is caused by latency in distributing the commands from the distribution database to the subscriber. So I’ll focus on ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on June 5, 2009
Privacy Statement