Replication?

  • Agreed, they are still delivered to the distributor (my bad for not clarifying that in my statement). What I meant to say was depending on the potential error at the subscriber, in a busy OLTP system, attempting to resolve the error can be a lot more work than simply re-snapping the table.

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • MyDoggieJessie (2/18/2014)


    Agreed, they are still delivered to the distributor (my bad for not clarifying that in my statement). What I meant to say was depending on the potential error at the subscriber, in a busy OLTP system, attempting to resolve the error can be a lot more work than simply re-snapping the table.

    Depends on the size of the table and the impact of producing the snapshot. In truly large and busy OLTP systems that I'm used to, this is not an option.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply