Answer

In order to restore a legacy database backup from a Data Protection for SQL node that is part of an AlwaysOn AAG configuration to a different SQL server where the Data Protection node is not enabled for AlwaysOn AAGs requires some configuration changes to the target (non-AAG node) as described below.

1) add the ALWAYSONNODE with the correct alwayson node name to the Data Protection for SQL config file (default is tdpsql.cfg) on the target SQL machine.

2) at the IBM Spectrum Protect server grant proxy access to the SQL node on the target server to the alwayson node. (Note: the agent node must be unique to each machine.)

To illustrate these changes assume we have the Data Protection for SQL node that is part of the alwayson config named SQL01_NODE. The alwayson node name used by SQL01_NODE is SQLALWAYSON. The Data Protection for SQL node name on the SQL server that is not part of the alwayson config is SQL_A_NODE

In the tdpsql.cfg configuration file add the line:

ALWAYSONNODE SQLALWAYSON

GRANT PROXYNODE target=SQLALWAYSON agent=SQL_A_NODE

To preform the restore

1. On the SQL server that is the target for the restore, start the MMC GUI.
2. Select the SQL server instance in the tree view and go to the Recover tab
3. In the middle of the pane near the top click the "DP NODE BACKUPS" button to toggle it to show "ALWAYSON NODE BACKUPS" and click refresh.
4. The backups for the SQLALWAYSON node should be displayed for restore.
5. To see the data originally backed up on SQL_A_NODE toggle the ALWAYSON NODE BACKUPS button back to DP NODE BACKUPS and refresh