I need your assistance - have exhausted all the troubleshooting options and still wasn't able to get things running.
The problem basically is the inability to backup the databases in a cluster. When I run the client, it only backups up databases that are not protected by cluster...
Environment:
Windows OS : Windows Server 2012 R2
SQL : SQL Server 2014
Networker: 9.0.1 b. 614
Windows Cluster name: alwayson.ad.xpto.com
Named Instance: LST-REC
Database name: CPI
I assume that there may be a configuration problem, but I wasn't able to find it until now.
What I did was - manually create three clients.. One for the Cluster name (LST-REC.ad.xpto.com) and two for the physical servers (svwa-bdc-cpd01.ad.xpto.com and svwa-bdc-cpd02.ad.xpto.com).
The configuration for the three clients are the same - the only difference is that the clients for the physical servers are not in any group and I start the backup only in the client for the cluster name.
.129292:(pid 31960): Successfully established Client direct save session for save-set ID '1471572332' (svwa-bdc-cpd01.ad.xpto.com:MSSQL$REC:master) with Data Domain volume 'sfdibkcpd01adxptocom.001'.
53085:(pid 31960):Backing up of master succeeded.
129292:(pid 31960): Successfully established Client direct save session for save-set ID '1454795122' (svwa-bdc-cpd01.ad.xpto.com:MSSQL$REC:model) with Data Domain volume 'sfdibkcpd01adxptocom.001'.
53085:(pid 31960):Backing up of model succeeded.
129292:(pid 31960): Successfully established Client direct save session for save-set ID '1438017909' (svwa-bdc-cpd01.ad.xpto.com:MSSQL$REC:msdb) with Data Domain volume 'sfdibkcpd01adxptocom.001'.
- define 3rd node which is using cluster name to access it - this one has to be shortname
- add to remote access of virtual node those physical ones
Configure backup for all 3 nodes since "local" nodes contain system DBs. I suspect you might have an issue with the fact that you use FQDN for backup of AAG DBs over cluster name which is something I have seen in past and since went for approach with shortname for cluster names.
I assume I've managed to do that - I have three clients, one for the instance name and two for the physical clients...
They all run successfully, but still only backups the standalone databases - it keeps saying that the CPI Database will be excluded as it is part of Availability group.
This saveset, backups all databases of instance SS01 in the availability group AGTCLU01.
As system databases are not in Availability group, you will need to backup them with the physycal nodes, as ussual (MSSQL$instance:master, MSSQL$instance:model, MSSQL$instance:msdb). Set a backup client for each physical node.
As ledugarte said, you don't specify name of AAG there. You only specified named instance, but for AAG there is futher naming convention (see docs or what ledugarte already mentioned in his post).
In your first post, you said your cluster name is LST-REC.ad.xpto.com and your windows cluster name is alwayson.ad.xpto.com.
What client instance you created for the cluster?. You should create client instances for each node, and cluster client should be created with "alwayson"...
Please make sure to check compatibility with version you use. Earlier versions of module didn't support AAG with named instances - do not know top of my head where this changed, but check release notes.
ble1
6 Operator
•
14354 Posts
•
56186 Points
4476
0
Posted September 11th, 2017 05:00
The way I do it:
- define nodes in AAG (FQDN) - normally two nodes
- define 3rd node which is using cluster name to access it - this one has to be shortname
- add to remote access of virtual node those physical ones
Configure backup for all 3 nodes since "local" nodes contain system DBs. I suspect you might have an issue with the fact that you use FQDN for backup of AAG DBs over cluster name which is something I have seen in past and since went for approach with shortname for cluster names.