Acronis Backup for Windows Server Essentials - User Guide - Manual (Page 307)

307 Copyright © Acronis International GmbH, 2002-2014
Follow these recommendations to ensure that a single-pass backup is successful.

Back up entire machines. This will allow you to recover both the operating system and any SQL
database present on a machine.
Databases may be stored on more than one disk or volume. To ensure that all necessary files are
included in a backup, back up the entire machine. This also ensures that the SQL Server will
remain protected if you add more databases or relocate the log files in the future.

If you do not want to back up an entire machine, select the volumes carefully.
If you are sure that the databases and their associated files are always on the same volumes, you
may want to back up only these volumes. Or, you may want to create separate backup plans for
the system volume and for the volumes that store the data.
You can also exclude files and folders (p. 59) if you are sure they do not belong to Microsoft SQL
Server.
In any case, make sure that all of the volumes containing the necessary files are included in the
backup. If, for example, the log file of a database is not included in the backup, you will not be
able to recover this database. Recovery of the operating system may not be possible if you did
not back up boot and system volumes or excluded critical system files.
For instructions on how to find out the database paths, refer to "SQL Server database files" (p.
281).

Use Volume Shadow Copy (VSS).
Make sure that the Volume Shadow Copy Service (p. 128) backup option is set to Use Volume
Shadow Copy Service and that the selected snapshot provider is not Software - Acronis VSS
Provider. The best choice is Software - System provider.
12.3.1 Single-pass backup settings
The settings described in this section relate to single-pass backup. These settings are grouped in the
Single-pass disk and application backup section of the Create backup plan (p. 54) or Back up now
page.
Single-pass backup
This setting enables single-pass disk and application backup.
To access the following settings, click Show task failure handling, log truncation.
Error handling
The Ignore application backup errors and continue the task check box determines the
software behavior when it fails to collect application metadata during a backup. For example,
this happens if a database is corrupted, or the application service is stopped, or using VSS is
disabled in the backup options, or the account under which the backup runs does not have
permissions to access a database.
By default, Acronis Backup fails the backup.
If you select the check box, the backup will continue. The event log will contain an entry
about each of the databases for which the metadata is not collected. If no metadata is
collected at all, you will obtain an ordinary disk-level backup.
The following setting is available only if Agent for SQL is installed on the machine.
Log truncation
If the setting is enabled, the Microsoft SQL Server log will be truncated after each full,
incremental or differential backup. The truncation occurs only if the single-pass backup was
successful.