
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hello,
I didnt find anywhere a detailed documentation on how to backup SQL Server Always on with DP 9.09.
The integration guide only names server cluster awareness, but thats it.
So far what I gathered from the forum:
Install the agents on both SQL nodes and then make the backup via the SQL listener.
But how to do that and make DP aware of the SQL listener name?
Thanks,
Thomas
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Thomas,
The correct way would be:
1. Push SQL integration to all SQL nodes (push installation not as cluster aware)
2. Go to Clients, Import client, type the availability group listener as a virtual client by selecting: Virtual Host
3. When you configure the Backup job select the Availability Group Lstener name.
Best Regards

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SQL Always on - Backup configuration
Hello Thomas,
What version of SQL are you running?
Regards

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SQL Always on - Backup configuration
Hi,
MS SQL 2014
Thanks,
Thomas

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SQL Always on - Backup configuration
The Term "Always On" seems to be specific to SQL 2017, but I am not sure about this. Data Protector does provide support for highly available SQL Clustered configurations, which is documented in the Integration User Guide. From the guide I have pasted relevant verbage:
In a cluster, all the nodes must be installed as Data Protector cluster-aware clients and the Data Protector Inet service on all nodes must run under a Windows domain user account that has also cluster administrator rights. You must configure the Data Protector Inet service user impersonation for all cluster nodes. The Windows domain user account that is used must be given the following Windows operating system Security Policy privileges: l Impersonate a client after authentication l Replace a process level token.
and
In Client, select the SQL Server system. For cluster environments, select the virtual server of the SQL Server resource group. For availability group configurations, select the availability group listener of the corresponding availability group. Note that you must first import the availability group listener as a virtual client by selecting Virtual Host in the Clients context. For details on how to import clients, see the HPE Data Protector Help index: “importing, client systems”.
I hope this helps.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Thomas,
The correct way would be:
1. Push SQL integration to all SQL nodes (push installation not as cluster aware)
2. Go to Clients, Import client, type the availability group listener as a virtual client by selecting: Virtual Host
3. When you configure the Backup job select the Availability Group Lstener name.
Best Regards

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SQL Always on - Backup configuration
Awesome, thanks to both of you, that did it. Awesome place here, much better then the old HP forum :-)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: SQL Always on - Backup configuration
Hi Thomas,
You're welcome :)
Best Regards