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.

Warning

Keep in mind that an agent needs to be installed on all nodes in the availability group that will be considered for backups.

How to install SQL Safe Backup and IDERA Dashboard while hosting the repository databases in an AlwaysOn environment?

Follow these steps:

  1. Log on with an administrator account to the computer on which you want to install SQL Safe Backup.
  2. Run SQL Safe Backup installer.
  3. Before you begin, the SQL Safe Backup wizard displays information about what is needed to complete the installation successfully. Click Next.
  4. Select the Full setup type to get started. Click Next.
  5. Review the license agreement. To accept this license agreement, select the I accept the Terms and Conditions checkbox. Click Next.
  6. Specify the Destination Folder where you want to install the SQL Safe Backup and IDERA Dashboard. Specify different path for each one. Click Next.
  7. Specify the SQL Server Instance of the availability group, Database Name, and Authentication you want to use for the SQL Safe Backup Repository.
    By default, the Windows Authentication is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the login name and password for this account, and click save.
    Make sure you enable the Same Instance and Authentication as above checkbox for the IDERA Dashboard Repository
    Before you continue, you can Test Connections to make sure the SQL Server instance is connected. Then, click Next.
  8. Specify the Service Account under which the SQL Safe Backup and IDERA Dashboard services will run under.
  9. Specify the account to be used by the SQL Safe Backup Management Service to connect to the SQL Safe Backup Repository Database.
    By default, the Windows account specified on the previous step is selected. If you want to use the Microsoft SQL Server Authentication, select this option and specify the respective SQL Sever login credentials, and click Next.
  10. Once SQL Safe is ready to install, review the settings you selected and click Install. If you want to edit your settings, select Back and make your changes.
  11. If not already available on the system, the Microsoft Visual C++ 2015 Update installation is requested. Click Install to install the program.
  12. When the SQL Safe installation completes, you can either:
    • Go to the Start Menu, select IDERA - SQL Safe Management Console.
    • Open the IDERA Dashboard through the URL https://localhost:9291 from a web browser.
    • Configure the Firewall.
    • Launch the SQL Safe Management Console.
  13. By default, the Launch the SQL Safe Management Console checkbox is enable. To complete the installation, disable it, then click Finish

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 deploy SQL Safe Backup in an AlwaysOn Environment.
  2. Once you install the SQL Safe Backup, configure 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 instructions. For more information, see install and configure the SQL Safe Backup Agent.

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

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 listener name should be used when generating a license key for the repository database.

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



Scroll pdf ignore
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

...

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

...