Versions Compared

Key

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

...

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, please see deploy SQL Safe Backup in an AlwaysOn Environment.
  2. Once you install the SQL Safe Backup, configure the Databases your databases for High Availability.
  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 the instructions. For more information, see Install install and Configure configure the SQL Safe Backup Agent.

To perform Backup and Restore operations on your primary and secondary replicas, see Availability Groupsavailability groups

Notewarning

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 listener name should be used when generating a license key for SQL Safe Backup is tied to the name of the SQL Server instance hosting the repository databasethe repository database.

In terms of licensing the agent, it still needs to be licensed for each replica.



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

...

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse