46750: Acronis Backup Advanced for SQL: Troubleshooting Backup Configuration

use Google Translate

Operating Systems: 

    Last update: 29-04-2021

    While configuring a backup plan to backup Microsoft SQL Databases with Acronis Backup, you may encounter problems setting up the MS SQL-related settings.

    Follow these steps to troubleshoot backup configuration issues in Acronis Backup & Recovery for Microsoft SQL Server:

    1. Get familiar with the used technology in the About part.
    2. Follow to Troubleshooting part to troubleshoot and resolve the issue.

    About single-pass backup

    Acronis Backup Advanced for SQL uses single-pass backup to protect MS SQL Server databases. A single-pass backup operation creates an application-aware disk backup which enables browsing and recovery of the backed-up application data without recovering the entire disk or volume. The disk or volume can also be recovered as a whole. This means that a single solution and a single backup plan can be used for both the disaster recovery and data protection purposes.

    The single-pass backup functionality becomes available by installing Acronis Agent for Microsoft SQL Server (single-pass).

    During a disk backup, Agent for SQL (single-pass) adds Microsoft SQL Server metadata to the resulting backup file. By using this metadata, Acronis Backup detects and catalogues SQL Server databases. After the backup is successfully completed, the agent truncates the SQL Server transaction log if the corresponding option in the backup plan has been set.

    See more about Acronis Backup Advanced for SQL in following articles:

    Title

    Related to

    Acronis Backup Advanced for SQL: Supported Microsoft SQL Server Versions Supported environment

    Troubleshooting

    Follow step-by-step instructions below to troubleshoot the issue. Complete prerequisites step before proceeding to error troubleshooting step.

    1. Prerequisites

    Make sure the requirements for MS SQL Server backup are fulfilled. Complete all steps before proceeding to error troubleshooting step

    1.1 Operating system should be supported

    Agent for SQL (single-pass) can be installed in the following operating systems: Supported Operating Systems.

    1.2 Microsoft SQL Server version should be supported

    Agent for SQL (single-pass) supports the following versions of Microsoft SQL Server: Supported Microsoft SQL Server versions.

    1.3 Agent for SQL (single-pass) should be installed

    Make sure the Agent for SQL (single-pass) is installed:

    • Connect the Management Console to the machine with the SQL Server.
    • Go to Help -> About.
    • Acronis Agent for SQL (single-pass) should be displayed.

    See help topic: Installation of Agent for SQL (single-pass).

    1.4 Check permissions for SQL Server backup

    To successfully perform a single-pass backup of a machine that is running Microsoft SQL Server, the account under which the backup plan runs must be a member of the Backup Operators or Administrators group on the machine.

    Also, this account must be granted the sysadmin role on each of the instances installed on the machine. See help topic: Permissions for SQL Server backup and recovery.

    1.5 License for Agent for SQL (single-pass) should be assigned

    To create a single-pass backup, a license for Agent for Windows and a license for Agent for SQL (single-pass) are required.

    Agent for SQL requires one of the following licenses:

    • Acronis Backup Advanced for SQL
    • Acronis Backup Advanced for SharePoint
    • Acronis Backup for Windows Server Essentials
    • Acronis Backup Advanced for VMware / Hyper-V / RHEV / Citrix XenServer / Oracle VM
    • Acronis Backup Advanced Universal License
    • Acronis Backup Advanced Prudct Subscription

    To install Agent for Windows, use any license that enables installation of this agent.

    If Agent for Windows is installed by using the Acronis Backup for Essentials license, you can install Agent for SQL (single-pass) without an additional license. Otherwise, use one of the following licenses:

    • Acronis Backup Advanced for SQL Add-on
    • Acronis Backup Advanced for SharePoint Add-on

    To check that the license is assigned to the machine, go to Help -> About.

    If all steps above have been executed and issue still persists, go to error troubleshooting step. 

    2. Error troubleshooting

    Select the section according to the issue. 

    2.1 Backup task creation issue

    When creating a backup plan, you may ancounter problems with the single-pass section.  

    2.1.1 Single-pass section does not appear in the backup plan

    Check that both the Agent for Windows and Agent for SQL (single-pass) are installed on the machine. See step 1.3. 

    2.1.2 License-related warning appears

    Make sure that you have assigned a license to the agent. See step 1.5.

    You may want to restart the Managed Machine Service if you have just assigned the license and it did not resolve the issue.

    2.1.3 Backup plan cannot be saved

    You have selected the SQL Server databases, but the OK button is grayed out.

    Make sure that you have specified all the necessary fields in the backup plan before you can save it. 

    2.2 SQL detection issue

    You have anabled the single-pass backup, but no SQL Server has been detected.

    Make sure that the SQL Server version and the OS are supported. See steps 1.1 and 1.2. 

    If all steps above have been executed and issue still persists, go to collect information step.

    3. Collect information

    Collect following information and contact Acronis Support

    3.1 Issue description

    Provide detailed issue descrition including screenshots of the backup plan settings.

    Provide the export of backup plan as xml file when available. 

    3.2 System information

    Connect the console to the machine with the issue, go to Help -> Collect system information.

    See Acronis Backup 11.7/11.5: Generating System Report.

    Tags: