Disaster planning advice needed

Hello, Could you please give me some guidance as to how I should approach disaster planning. I am about to begin a new position with a new company. I will be working on designing a disaster recovery plan. My new company is trying to use multimaster replication for this. The failover will only become available to users when the primary fails. No users will be attached to the failover while the primary is active. In the event of a failure the failover site is to become the primary. The fail over site does not reside in the same location as the primary db.

My opinion is that we should use a hot backup site for this scenario. Can you also comment about this plan?

How are others approaching this situation? What are the trade offs between a hot standby and multimaster replication? What is the downside to either approach?
Are there any third party tools to help in maintaining a hot standby database?

Thank you for your help. Received on Wed Feb 03 1999 - 13:32:39 CST