Replicate the Information Store in SQL Server

After you create the Information Store database on the primary database server, add the database to your availability group and replicate the Information Store database to your standby servers.

Procedure

  1. Before you can add the Information Store database to your availability group, you must create a full backup. For more information, see Create a Full Database Backup.

  2. Add the Information Store database to your availability group. For more information, see Add a Database to an Always On availability group.

  3. Add any replicas to the availability group. For more information, see Add a secondary replica to an Always On Availability Group. When you add the replicas to the availability group, configure the replicas as follows:

    • Set Failover Mode to Automatic

    • Set Availability Mode to Synchronous commit

    • Set Readable Secondary to Yes

      If you are using Basic availability groups, set it to No.

What to do next

Continue the deployment process. For more information, see Deploying i2 Analyze with high availability.