ApexSQL Recover – Permissions and requirements

Applies to
ApexSQL Recover

Summary
This article provides information about required permissions and software requirements for ApexSQL Recover.

Description

Required permissions for application installation

The Windows user account used to install ApexSQL Recover must have Windows administrator permissions.

Installation of ApexSQL Recover server-side components (SSC) additionally requires the Windows user account to be a member of the fixed SQL Server sysadmin role.

Note that in case of remote server-side components installation, the Windows UAC feature must be disabled on the remote target machine.

Required permissions for recovering deleted, dropped, truncated data, deleted blobs, or extracting blobs

The Windows user account used to run ApexSQL Recover must have Windows administrator permissions. The following additional SQL Server permissions are required:

  • GRANT VIEW ANY DATABASE
  • GRANT VIEW ANY DEFINITION
  • db_owner or the following permissions:
    • GRANT SELECT ON [sys].[partitions]
    • GRANT SELECT ON [sys].[syscolumns]
    • GRANT SELECT ON [sys].[allocation_units]
    • GRANT SELECT ON [sys].[partitions]
    • GRANT SELECT ON [sys].[system_internals_partition_columns]
    • GRANT SELECT ON [sys].[system_internals_partitions]
    • GRANT SELECT ON [sys].[syscolumns]

Note that in case a remote SQL Server database is recovered, the GRANT EXECUTE ON OBJECT::master.dbo.xp_ApexSQLRecover is required.

Required permissions for extracting data from a database backup

The Windows user account used to run ApexSQL Recover must have Windows administrator permissions.

Software requirements

ApexSQL Recover software requirements are specified on the System requirements page.

Hardware requirements

Both minimum and recommended hardware requirements for ApexSQL Recover are the same as described on the Hardware and Software Requirements for Installing SQL Server page.