Queued Updating Subscriptions data recovery

  • In the event that we had to fail over to our remote subscriber due to a catastrophic failure and we were unable to recover our publisher/publication, what would happen to the data that the queue reader agent? The queued data will be waiting for the publication to become available again which will never happen. Is there a way to get that queued data to be written to the subscriber database?

  • What type of replication are you using, Merge?

  • I'm using transactional replication with queued updatable subscriptions.

Viewing 3 posts - 1 through 2 (of 2 total)

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