Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
PowerProtect Data Manager: Microsoft SQL Database Backup and Recovery
Executive summary Data Manager overview Deployment requirements
Network
Microsoft application agent
SQL host
Security SQL database backup SQL database recovery Support for existing SQL agent backups with Data Manager Disaster recovery Technical support and resources

SQL host

SQL host

  • On the Microsoft SQL Server host, install the Microsoft application agent and configure the installation options. Download the Microsoft application agent .zip file, from the Dell Technologies support site to the Microsoft SQL Server host. Extract the .zip file and run the .exe file to start the installation wizard.

    Prerequisites for Always on Availability Group (AAG) protection

    Agent installation: For Microsoft SQL Always on Availability environment, the Microsoft application agent needs to be installed on each node in the cluster. If a database is protected in an Always on Availability Group (AAG), stand-alone backups cannot be configured of that database in a protection policy group. SQL AAG requires a Microsoft Cluster Service (MSCS) starting from SQL Server 2017.

    Lockbox configuration: Either a single shared lockbox or a separate lockbox must be configured on each node that is in the Always on Availability Group.

    Set Readable Secondary settings: Set the Always on Availability Group readable secondary configuration option to either yes or read intent only:

    1. On SSMS, in the Object Explorer, right-click the Always on Availability Group and select Properties. The Availability Group Properties dialog box appears.
    2. In the availability replicas table, readable secondary column, select either yes or read intent only for each of the primary and secondary replicas of the SQL Server instances. This setting allows the Microsoft application agent to gather information about the secondary replica (for example, database file location, which can be different from the other replicas).

    See PowerProtect Data Manager Compatibility Guide for supported Microsoft application agent versions and Microsoft SQL Server versions with the Data Manager.

    Data Manager support for SQL AAG and SQL cluster-less AAG environment

    Data Manager supports both SQL AAG and SQL cluster-less AAG environment for database protection and recovery.

    Database discovery on Data Manager

    Database discovery

    Database backup

    Value

    Standalone database backups

    Local hostname

    Clustered Availability group database backup

    Cluster name

    Cluster less Availability group database backup

    AGName_AGGUID'

    SQL virtual server database backup

    Network name

    Clustered SQL AAG database discovery on Data Manager

    The following figure represents the SQL AAG database which is shown as assets for data protection.

    Cluster-less SQL AAG database discovery on Data Manager

    The following figure shows that the cluster-less SQL AAG database appears as assets for data protection.

    The following features are supported with Application Direct and VM application-consistent backups:

    • Centralized backups from Data Manager
    • Self-service backups (only Application Direct)
    • Self-service database restore options
    • Point in Time (PIT) restore
    • Restore to latest point
    • Table-level restore
    • Instance access of the database (only VM Direct)
    • Alternate restore
    • Flat-file restore