MQSeries.net :: View topic - Disaster recovery

amackie · Posted: Tue Aug 10, 2004 7:33 am Post subject:

What means of resending messages is typically used in recovery situations ? Consider -

An application receives messages from a message queue, & writes data to a database. Application fails or user screws up, and database needs to be restored - say, last nights backup. Now need to resubmit / replay messages that were previously received.

Some thoughts:
1. The application should be maintaining it's own backup of messages - not a message queue problem.
2. Use a utility to replay messages from the message queue.
3. Use high availability database to provide point-in-time restore (but how do we get the missing messages back in?)

What options exist for Websphere MQ or MSMQ ? One option I found was ReQuest from Cressida: http://www.cressida.info/products_am_mqla.shtml

Does MQ not support this directly ?

Thanks,
Andy Mackie