SQL Always on - Backup configuration

[THOMAS KOFLER]

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

[THE_DP_GURU]

Hello Thomas,

What version of SQL are you running?

Regards

[THOMAS KOFLER]

Hi,

MS SQL 2014

Thanks,
Thomas

[THE_DP_GURU]

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.

[fbrenes · Accepted 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  

[THOMAS KOFLER]

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

[fbrenes]

Hi Thomas,

You're welcome :)

Best Regards