SQL

Moving the Acronis Management Server directly is not possible, however there are a few steps that could assist you.

MS SQL Server support. Basic support of Windows 8 and Windows Server 2012

MS SQL Server 2005/2008/2008R2/2012/2014 are supported

While performing a single-pass backup from SQL instance, you receive this error. To solve this issue make sure, that the SQL instance accepting remote connections or remove database mirroring prior to restore.

To fix the issue, edit Windows Registry or download and replace a DLL file

 

You need to free up additional disk space or change location of temporary files

MS SQL Server does not allow log truncation for databases that do not have native full backups. Create a native SQL full backup of that database once

Change Acronis databases to Simple Recovery model

By default, MS SharePoint on Windows SBS does not have any MS SQL user with the sysadmin role.

You need to assign the sysadmin role for proper Acronis SharePoint operation.

Take the following steps to give any Windows user an MS SQL sysadmin role:

Liste des limitations dans les versions d'évaluation des produits Acronis

You are backing up an entire machine with the Application-aware backup option enabled. You have selected SQL, Exchange, or both.

After some time, you change the password for the user that has been specified during activation of the feature.

The backup starts failing with the following error message:

Logging on with the specified credentials is impossible, probably because the account does not exist or the password is invalid.

You can optimize energy consumption, network load and backup performance by adjusting multiple settings in Acronis Backup Cloud, like performance, backup compression, backup start time and others. This article provides you with details on these settings.

Acronis Recovery for MS SQL Server is a comprehensive backup and recovery tool for databases and entire Microsoft SQL Server instances

This article describes the product that is out of support lifecycle. Current version of the product is Acronis Backup 12.5 and MS SQL Server backup is included in Server licenses.

 

Symptoms

 

  1. You try to back up SQL databases: either by selecting databases directly or using disk-level backup with enabled Microsoft SQL Server application backup
  2. Backup fails with the following error:

    Backup failed.
    Failed to get additional information about file 'D:\MSSQL\03\Database1.mdf'.

Follow these steps to troubleshoot issues with single-pass backup of SQL Server databases:

Symptoms

Application-aware backup of SQL databases finishes with the following warning:

Cannot get the file list of Microsoft SQL database '...'. 

After you have disabled SSL 3.0, TLS 1.0, TLS 1.1 and left only TLS 1.2 running on the machine, application-aware backup of an SQL server finishes with a warning:

Error code: 4358
Module: 87
LineInfo: 0xEC865955C73BB27A
Fields: {"$module":"aavb_mssql_backuper_vsa64_11010"}
Message: Failed to collect the metadata of the SQL Server databases selected for backup. The databases will not be backed up.

If you try to edit of specify credentials for an SQL server user, you get these errors:

Cannot collect the metadata of Microsoft SQL Server
The specified user is not a member of the sysadmin role in SQL Server instance 'Instance_name'.
Cannot collect the metadata of Microsoft SQL Server
Cannot back up the SQL Server instances due to environment issues.

All conditions must be true:

  1. Act! software and Microsoft SQL Server are installed
  2. Acronis True Image does not create a backup. If you click the red exclamation mark at the center of the backup screen, the following error message is displayed:
    1. Entire PC and disk/partition backups: Unable to create volume snapshot
    2. File and folder backup: Failed to backup file or folder
  3. The last modified log file at C:\ProgramData\Acronis\TrueImageHome\Logs\ti_demon contains the following text: VSS writer 'SqlServerWriter' with class ID 'A65FAA63-5EA8-4EBC-9DBD-A0C4DB26912A' has failed to process the snapshot

Table of trial limitations of Acronis products

  1. You use Acronis Backup 12.5 or Acronis Cyber Cloud
  2. You run a backup of a Microsoft SQL database
  3. Backup fails with the following error:

Problems detected that may cause a VSS snapshot failure. Trailing spaces in the path. To remove the trailing spaces, run the T-SQL command: ALTER DATABASE MODIFY FILE

A single-pass backup (aka application-aware backup) is a disk backup containing metadata of VSS-aware applications that are present on the disk. This metadata enables browsing and recovery of the backed-up application data without recovering the entire disk or volume.

Single-pass is available for machines running SQL Server, SharePoint Server and Active Directory. Single-pass is not available for Microsoft Exchange.

Having Acronis Backup, you will see following new part (on local management or centralized management console) when Create backup plan:

How to move AMS or its SQL databases to another machine.

Backup on Windows XP fails with error "Failed to create volume snapshot" if MS SQL Server is installed.

Summary: list of available support options for Acronis products

Pages

You are reporting a typo in the following text:
Simply click the "Send typo report" button to complete the report. You can also include a comment.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
7 + 11 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.