AlwaysOn Availability Groups are part of an integrated solution, introduced in SQL Server 2012 with the goal of achieving the highest level of data availability and disaster recovery for organizations.
Availability Groups grant DBAs the ability to automatically or manually failover a group of databases as a single unit with support for up to four secondary replicas. For additional information on availability groups, see the Microsoft document,
| Newtab2 |
|---|
| alias | Overview of AlwaysOn Availability Groups (SQL Server) |
|---|
| url | https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-2017 |
|---|
|
.
The SQL Safe Backup supports SQL Server Availability Groups and allows you to perform backup and recovery strategies on your primary and secondary replicas.
To install the SQL Safe Backup Management Components while targeting an availability group for the databases, follow these steps:
- Install the SQL Safe Backup with repository databases hosted in an availability group. For more information, see
| Newtab2 |
|---|
| alias | deploy SQL Safe Backup in an AlwaysOn Environment |
|---|
| url | http://wiki.idera.com/x/LwCEBg |
|---|
|
. - Once you install the SQL Safe Backup,
| Newtab2 |
|---|
| alias | configure the Databases for High Availability |
|---|
| url | http://wiki.idera.com/x/MgCEBg |
|---|
|
. Launch the SQL Safe Management Console from the Start menu.
| Warning |
|---|
Keep in mind, an agent needs to be installed on all nodes of the availability group that will be considered for backups. To install the SQL Safe Backup Agent on each node of the availability group, please follow the | Newtab2 |
|---|
| alias | instructions |
|---|
| url | http://wiki.idera.com/x/Agoh |
|---|
|
. For more information, see | Newtab2 |
|---|
| alias | Install and Configure the SQL Safe Backup Agent |
|---|
| url | http://wiki.idera.com/display/SQLSAFE/Install+and+Configure+the+SQL+Safe+Backup+Agent |
|---|
|
. |
To perform Backup and Restore operations on your primary and secondary replicas, see
| Newtab2 |
|---|
| alias | Availability Groups |
|---|
| url | http://wiki.idera.com/x/nQU1 |
|---|
|
.
| Warning |
|---|
In an AlwaysOn Environment, the SQL Safe Backup will require a license key for each replica to ensure continued functionality of the product after a failover event. The license key for SQL Safe Backup is tied to the name of the SQL Server instance hosting the repository database. |