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:
- Get familiar with the used technology in the About part.
- 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:
|Acronis Backup Advanced for SQL: Supported Microsoft SQL Server Versions||Supported environment|
Follow step-by-step instructions below to troubleshoot the issue. Complete prerequisites step before proceeding to error troubleshooting step.
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.