Do you have feedback on our new interface?
Do you have feedback on our new interface? Let us know HERE
Highlighted
Established Member.. THOMAS KOFLER
Established Member..
474 views

SQL Always on - Backup configuration

Jump to solution

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

 

0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

Re: SQL Always on - Backup configuration

Jump to solution

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
Micro Focus Expert

Re: SQL Always on - Backup configuration

Jump to solution

Hello Thomas,

 

What version of SQL are you running?

 

Regards

0 Likes
Established Member.. THOMAS KOFLER
Established Member..

Re: SQL Always on - Backup configuration

Jump to solution

Hi,

MS SQL 2014

Thanks,
Thomas

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: SQL Always on - Backup configuration

Jump to solution

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
Micro Focus Expert

Re: SQL Always on - Backup configuration

Jump to solution

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  

Established Member.. THOMAS KOFLER
Established Member..

Re: SQL Always on - Backup configuration

Jump to solution

Awesome, thanks to both of you, that did it. Awesome place here, much better then the old HP forum :-)

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: SQL Always on - Backup configuration

Jump to solution

Hi Thomas,

You're welcome :)

Best Regards

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. 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.