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

305 Copyright © Acronis International GmbH, 2002-2014
Granting the permissions to the agent
During installation, the setup program includes the agent service account in the Backup Operators
group. If you choose to create a new account for the agent, this account is also included in the
Administrators group. Therefore, the agent always has the required privileges in Windows.
To grant the agent the sysadmin role in SQL Server, you are asked to specify the sysadmin
credentials for each Microsoft SQL instance installed on the machine. If you do not specify the
credentials during installation, you can grant the agent the sysadmin role later in any of the following
ways:

By clicking Tools > Provide SQL Server credentials when Acronis Backup Management Console is
connected to the machine.

By using SQL Server Management Studio.

By running a T-SQL script.
You must also grant explicitly the agent the sysadmin role after a new Microsoft SQL Server instance
is installed on the machine.
To grant the agent service account the sysadmin role on an instance by means of a T-SQL script
1. Create a text file with the following contents:
Create Login [<machine name>\Acronis Agent User] From Windows
Exec master..sp_addsrvrolemember @loginame = '<machine name>\Acronis Agent
User',@rolename = 'sysadmin'
Acronis Agent User is the account created for the agent by default. If you specified an
existing account during the agent installation, replace Acronis Agent User with the user name
of the existing account.
The file can have any extension.
2. At the command prompt, run the following command:
sqlcmd -S <machine name>\<instance name> -i <full path to T-SQL script file>
If you do not want to grant the sysadmin role to the agent, you must specify credentials in every
backup plan as described at the beginning of this section.
Permissions required for recovering a Microsoft SQL Server database
When recovering a database to an instance, you need to specify credentials for this instance. The
prompt for the credentials appears after you select the destination instance on the Recover data (p.
131) page.
12.1.5 What else you need to know about single-pass backup
Single-pass backup is performed at a disk level. This results in the following peculiarities for this
backup type:

Databases located on network shares cannot be backed up.

Filegroups are backed up and recovered as a whole database. An individual file cannot be
recovered so that the database is operational.

Databases cannot be recovered to any point in time, but only to a point in time when the data
snapshot was taken. If you back up transaction logs by using the SQL Server backup and restore
component, you can further apply these logs to reach the desired recovery point.