NOTICE: Branded Content
NOTICE: Certain versions of content (“Material”) accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.
Data Protector User Discussions
cancel

SQL Always on - Backup configuration

SOLVED
Go to solution
Highlighted
Member.. THOMAS KOFLER
Member..

SQL Always on - Backup configuration

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
 Micro Focus Expert fbrenes  Micro Focus Expert
 Micro Focus Expert
Solution

Re: SQL Always on - Backup configuration

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  

6 REPLIES
 Micro Focus Expert THE_DP_GURU  Micro Focus Expert
 Micro Focus Expert

Re: SQL Always on - Backup configuration

Hello Thomas,

 

What version of SQL are you running?

 

Regards

Member.. THOMAS KOFLER
Member..

Re: SQL Always on - Backup configuration

Hi,

MS SQL 2014

Thanks,
Thomas

 Micro Focus Expert THE_DP_GURU  Micro Focus Expert
 Micro Focus Expert

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.

 Micro Focus Expert fbrenes  Micro Focus Expert
 Micro Focus Expert
Solution

Re: SQL Always on - Backup configuration

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  

Member.. THOMAS KOFLER
Member..

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 :-)

 Micro Focus Expert fbrenes  Micro Focus Expert
 Micro Focus Expert

Re: SQL Always on - Backup configuration

Hi Thomas,

You're welcome :)

Best Regards