SQLTeam.com | Weblogs | Forums

SQL Merge Replication DR Planning

In a proactive approach I'm planning to make a database Disaster Recovery environment.

I have set a environment with this structure:

Database1: Publisher
Database2: Subscriber of Database1 + Publisher of Database3
Database3 Database3: Subscriber of Database2
All databases are on different physical machines in different locations: All databases have 5 different publications named Pub1, Pub2, Pub3, Pub4, Pub5

I just dropped a Subscriber (Pub3) on Database3

What will be the best approach to restore dropped subscriptions?
by considering mentioned points:

  1. Each publication have more than 200 tables and database size is almost 800GB.
  2. Each Database is on different location & Machines (Network Involved)
  3. Having very Short Recovery Time