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. Additionally, ports 60408 and 65100 need to be open on both local and remote machines for two-way communication.
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 SQL Server permissions for reading transaction log files:
- 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 you run ApexSQL Recover on a remote SQL Server database, 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.
