Replicate data between primary and secondary sites
Replicate the data between the primary and secondary sites. This process involves database replication using publisher and subscriber models in Microsoft SQL Server Management Studio, server repository replication using Windows Distributed File System (DFS), and backing up Elasticsearch (audit log) data.
Before installing Automation 360, ensure that you have set up your secondary site.
Configure the database and shared repository in the secondary site that is used for disaster recovery. Back up your Elasticsearch data by setting up the backup cluster.
Replicate the database from the primary site to the secondary site using
the publisher and subscriber models in Microsoft SQL Server Management Studio.
- Use the Microsoft SQL Server Developer or Enterprise
edition for database replication.
The publisher and subscriber versions should be the same, or the gap between the two versions should not be more than two releases. For example, do not use Microsoft SQL Server 2012 publisher with Microsoft SQL Server 2019 subscriber.
- Configure the publisher and distributor on the same machine to avoid
latency in data sharing.
Use different machines only for load distribution, for example, for data larger than 200 GB.
For detailed steps, see Database Mirroring and Replication (SQL Server).
- Connect to the primary database to create a snapshot publication for your local publications.
- Add the tables and views as articles.
- Use the snapshot agent option to create a snapshot and keep the snapshot available to initialize subscriptions.
- Schedule the snapshot agent to back up the data at regular intervals (for example, every 10 seconds from 12 AM to 11:59:59 PM).
- To select the account to run the snapshot agent, configure the security and agent settings.
- Add a publication option.
- Run all agent and distributors after ensuring the publisher and database names are correct.
- To add subscribers to the local subscriptions, connect to the database server and provide connection details for the database at the secondary site.
- Use the Microsoft SQL Server Developer or Enterprise edition for database replication.
Replicate the repository (bots and data files) using the
Windows Distributed File System (DFS) from the primary site to the secondary
For detailed steps, see Distributed File System Replication.
- Open the Distributed File System on the machine where the shared repository is saved.
Create a new multipurpose replication group to add replication group
The group members include the source machine in the primary site and the destination machine in the secondary site to store the shared repository.
- Use the full mesh option for DFS replication groups composed of less than 10 servers.
- Use the full bandwidth option to replicate the data continuously.
- Add the machine where you are configuring the repository as a primary member.
- Add a backup folder for the shared repository from the destination machine.
- Verify the data is replicated in the backup folder on the destination machine.
Back up the Elasticsearch (audit log) data by adding
the secondary site cluster IP address in the Control Room on the
For detailed steps, see Configure disaster recovery site for Elasticsearch IP addresses.