2 installation of agent for sql, 3 backing up microsoft sql server, Installation of agent for sql – Acronis Backup for Windows Server Essentials - User Guide User Manual

Page 306: Backing up microsoft sql server

Advertising
background image

306

Copyright © Acronis International GmbH, 2002-2014

12.2 Installation of Agent for SQL

Agent for SQL can only be installed on a machine running Microsoft SQL Server. Remote installation
of the agent is not possible.

The agent is included in the setup program of Acronis Backup Advanced.

The agent is installed with Agent for Windows (p. 16) or on a machine where Agent for Windows is
already installed.

Licenses 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

Each of these licenses enables you to install Agent for Windows on the same machine. If Agent for
Windows is already installed, you can install Agent for SQL by using one of the add-on licenses:

Acronis Backup Advanced for SQL Add-On

Acronis Backup Advanced for SharePoint Add-On.

To use the product in the trial mode, you do not need licenses.

Installation

Install the agent in the same way as Agent for Windows. For detailed step-by-step instructions, refer
to the "Interactive installation of Acronis Backup Advanced" section of the installation
documentation.

Credentials for Microsoft SQL instances

During the installation, you are asked to specify the sysadmin credentials for each Microsoft SQL
instance installed on the machine. These credentials are required to grant the sysadmin role to the
agent service account.

You can skip entering the credentials and 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.

For more information, see "Permissions for SQL Server backup and recovery" (p. 304) in the product
Help or the User Guide.

12.3 Backing up Microsoft SQL server

To protect a Microsoft SQL server, create a backup plan or use the Backup now feature as described
in the "Backup" (p. 54) section.

Advertising
This manual is related to the following products: