Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    7

    Angry Unanswered: Dump Database Coming through in Replication

    Database Dump commands that are wrapped in an explicit transaction are being replicated and wind up failing at the replicate and bringing down the connection. Whats the best way to filter these out ? Is there a settable option ?

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    A stupid question maybe - why are the database dumps wrapped in an explicit transaction?

    Michael

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    the trick to work around this issue is to have a login trigger on the login that uses dump in an explicit transaction. The login trigger should simply set replication off. This way the dump will never be sent across.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •