Thanks for the screen shots!! Can you post the AG owner instances (Instances names used for AG creation). Hope in both the nodes "SQL Standalone instances are running"; I mean, no SQL Virtual server is configured for this AG. Couple of follow-up queries:-
1. Did you try to configure using NMC Client configuration wizard?
2. Did you provided the SQL Server credentials in the NMC Client (Remote user and pwd field)
3. Did you try to run the AAG backup using debug level = 9 (-D9)
ble1
4 Operator
•
14.4K Posts
0
October 18th, 2016 04:00
With NMM 8.x that works for sure. Did you use cluster name as client resource?
Elviz42
37 Posts
0
October 24th, 2016 06:00
Hi Hrvoje,
yes, I have a Cluster client ressource.
Regards
Heiko
ElanC
53 Posts
0
October 26th, 2016 02:00
Are these AAG (AlwasyOnGroup) configured with Default SQL Instance or Named SQL Instances? Below saveset entries are pertains to default instances.
MSSQL:
MSSQL#
MSSQL# :
You may need to include the correct SQL instance name in the saveset to complete the backup without any issues.
ElanC
53 Posts
0
October 26th, 2016 03:00
MSSQLSERVER is for a default instance. Pls. check whether the AG db's are configured with Named instance.
Elviz42
37 Posts
0
October 26th, 2016 03:00
Server instance is "MSSQLSERVER" which is Standard I think.
Regards
Heiko
Elviz42
37 Posts
0
October 26th, 2016 05:00
In the properties of the AG there is no instance defined.
Elviz42
37 Posts
0
October 26th, 2016 05:00
Get-ItemProperty 'HKLM:\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL'
PSPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL
PSParentPath : Microsoft.PowerShell.Core\Registry::HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names
PSChildName : SQL
PSDrive : HKLM
PSProvider : Microsoft.PowerShell.Core\Registry
MSSQLSERVER : MSSQL11.MSSQLSERVER
ElanC
53 Posts
0
October 26th, 2016 05:00
Can you post the screen shot of AG properties (using Primary replica)?
Elviz42
37 Posts
0
October 26th, 2016 07:00
Cluser nodes are "dghams200" and "dghams201". AO Cluster is "dghams203".
Elviz42
37 Posts
0
October 26th, 2016 07:00
Elviz42
37 Posts
0
October 26th, 2016 07:00
ElanC
53 Posts
0
October 31st, 2016 00:00
Thanks for the screen shots!! Can you post the AG owner instances (Instances names used for AG creation). Hope in both the nodes "SQL Standalone instances are running"; I mean, no SQL Virtual server is configured for this AG. Couple of follow-up queries:-
1. Did you try to configure using NMC Client configuration wizard?
2. Did you provided the SQL Server credentials in the NMC Client (Remote user and pwd field)
3. Did you try to run the AAG backup using debug level = 9 (-D9)
Please revert the above details....