AlwaysOn Availability Group Considerations

Parent Previous Next

Considerations Before Installing to an AlwaysOn Availability Group

When a user wishes to install the BI xPress database to an AlwaysOn Availability Group as an availability database, certain considerations should be made.

Important Note:

This isn't intended to be a guide for configuring an AlwaysOn Availability Group. This guide is assuming that an AlwaysOn Availability Group has already been properly configured and the user wishes to add the BI xPress database to an existing availability group as an availability database.

Client Installation

Unlike Workbench Server, Pragmatic Workbench does not require any additional setup instructions before beginning the process of configuring Pragmatic Workbench's databases to work within an AlwaysOn Availability Group.

Once Pragmatic Workbench installation has been completed, creation of the BI xPress databases can be done through the Pragmatic Workbench UI. When creating the BI xPress database, ensure that the databases are configured so that its server settings are set to point to the availability group listener. After the database has been created, the user can continue on to adding the databases to the availability group as an availability database.

Important Note:

If users wish to use an existing BI xPress databases, they can execute a full recovery back up of their database and restore it on their primary availability replica before continuing to add the database to an availability group.

Adding the databases to the Availability Group

Once the database(s) have been created, the database(s) can now be added as availability database(s) to the availability group. This is done in the exact same way a user would add any other database to an availability group:

1.   Within the database properties, ensure that the databases' recovery model is set to "Full"

2.   Create a network share that each availability replica has permissions to access

3.   Create a full back up of each database on the network share created in Step 2

4.   Once all of the databases have a full back up located on a network share, expand "AlwaysOn High Availability" within management studio's object explorer

5.   Right-click on the availability group that the user wishes to add the database(s) to and select "Add Database..."

6.   Walk through the steps within the "Add Database to Availability Group" wizard, ensuring the database(s) selected meet all of the prerequisites. On the "Select Data Synchronization" page, select "Full" and specify the network share created in Step 2 as the location accessible by all replicas

Once the BI xPress database has been added to the availability group as an availability database, whenever a user wishes to connect to the databases, the user should connect through the availability group listener.