PowerProtect Data Manager 19.12 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, msappagent1912_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 and facilitate the discovery of assets with the correct size. Setting the sysadmin privilege for Microsoft SQL Server hosts provides more information.