Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
aliasOverview of AlwaysOn Availability Groups (SQL Server)
urlhttps://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:

  1. Install the SQL Safe Backup with repository databases hosted in an availability group. For more information, see 
    Newtab2
    aliasdeploy SQL Safe Backup in an AlwaysOn Environment
    urlhttp://wiki.idera.com/x/LwCEBg
    .
  2. Once you install the SQL Safe Backup, 
    Newtab2
    aliasconfigure the Databases for High Availability
    urlhttp://wiki.idera.com/x/MgCEBg
    .
  3. 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
    aliasinstructions
    urlhttp://wiki.idera.com/x/Agoh
    . For more information, see
    Newtab2
    aliasInstall and Configure the SQL Safe Backup Agent
    urlhttp://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
urlhttp://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.

Scroll pdf ignore
SQL Safe is a high-performance backup and recovery solution for your SQL Servers. Learn more > >

Scroll Pagebreak