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:
- Each publication have more than 200 tables and database size is almost 800GB.
- Each Database is on different location & Machines (Network Involved)
- Having very Short Recovery Time