tags:

views:

218

answers:

3

MSMQ stores messages on file system. Is there no way to configure MSMQ to store messages in database? I looked for options but couldn't find any?

+2  A: 

Read the MSMQ FAQ.

Mr. Smith
+1  A: 

There is no way. By the way, why would you like to do that?

Igal Serban
It would have been easy if the storage is in database. In case of a crash disaster recovery site will be activated and for that we are keeping database in sync. If we use MSMQ then we need to keep file system also in sync.
Bhushan
A: 

We have the same problem.

We want a failover Site to have the same data that is persisted in the private queues on the first Site.

If the first Site goes down we want to bring up the second site and have the persisted messages intact.

Is there a feature inside MSMQ to replicate data?

David
David for this reason I am considering database Queues as provided by both SQL Server and Oracle
Bhushan