2 supported operating systems, 3 supported microsoft sql server versions, 4 permissions for sql server backup and recovery – Acronis Backup for Windows Server Essentials - User Guide User Manual

Page 304

Advertising
background image

304

Copyright © Acronis International GmbH, 2002-2014

Mounting databases

By using the agent, you can temporarily attach a backed-up database to a running SQL Server
instance and use third-party tools to get various objects from this database.

12.1.2 Supported operating systems

Agent for SQL can be installed in the following operating systems:

Windows Server 2003/2003 R2 – Standard and Enterprise editions (x86, x64)
Windows Small Business Server 2003/2003 R2
Windows Server 2008 – Standard, Enterprise, and Datacenter editions (x86, x64)
Windows Small Business Server 2008
Windows 7 – all editions except for the Starter and Home editions (x86, x64)
Windows Server 2008 R2 – Standard, Enterprise, Datacenter, and Foundation editions
Windows MultiPoint Server 2010/2011/2012
Windows Small Business Server 2011 – all editions
Windows 8/8.1 – all editions except for the Windows RT editions (x86, x64)
Windows Server 2012/2012 R2 – all editions
Windows Storage Server 2003/2008/2008 R2/2012/2012 R2

12.1.3 Supported Microsoft SQL Server versions

Agent for SQL supports the following versions of Microsoft SQL Server:

Microsoft SQL Server 2005

Microsoft SQL Server 2008

Microsoft SQL Server 2008 R2

Microsoft SQL Server 2012

Microsoft SQL Server 2014

12.1.4 Permissions for SQL Server backup and recovery

Permissions required for a single-pass 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.

If you create a backup plan while you are logged on as a regular user, such as a member of the Users
group, you need to specify the credentials for the account that has the above privileges. To access
this setting, click Plan's credentials on the Create backup plan (p. 54) page.

A backup plan created by a member of the Administrators group runs under the agent service
account by default. The same applies to a centralized backup plan deployed from the management
server. That's why it is advisable to assign the agent the permissions required for single-pass backup.

Advertising
This manual is related to the following products: