PowerProtect Data Manager Appliance 5.16.0.0 Microsoft SQL Server User Guide

Ensure that a Microsoft SQL Server environment meets the following prerequisites before you install the Microsoft application agent:

• Install the following applications on the Windows host:
  • Microsoft SQL Server

  • .NET Framework 4.0

    If you are installing ItemPoint for table-level recovery, install .NET Framework 4.5.

• Ensure that you have a minimum of 2 GB disk space for the installation of the Microsoft application agent.

  NOTE:The required log space continues to increase based on the activity on the application agent host. You can estimate the required log space based on the retention period of the logs as set by the user.
• In the PowerProtect Data Manager UI, click and select Downloads from the System Settings menu. Under Microsoft SQL Server, select Download Agent to download the Microsoft application agent download package, msappagent1916_win_x64.zip, to the Windows Microsoft SQL Server host.
• Log in to the Microsoft SQL Server host as an administrator to install the Microsoft application agent.
• To deploy the Common Language Runtime (CLR) assembly, ensure that you have administrator access to the Microsoft SQL Server host and master database. If the Microsoft SQL Server host is running in a domain, ensure that you have access as a Domain administrator.
• Ensure that the required permissions are set up for the discovery of Microsoft SQL Server instances and databases by the PowerProtect agent service. Required privileges for Application Direct backup and recovery provide more information.
• Ensure that the sysadmin privilege is set, as required to integrate the Microsoft SQL Server host with the PowerProtect Data Manager Appliance and facilitate the discovery of assets with the correct size. Setting the sysadmin privilege for Microsoft SQL Server hosts provides more information.
• For an FCI configuration, the Microsoft application agent must always be installed on an active node of the cluster. To install on another node, you must fail over the cluster to a secondary node to make it the active node and then install the MIcrosoft application agent.