4 Operator

 • 

14.4K Posts

October 18th, 2016 04:00

With NMM 8.x that works for sure.  Did you use cluster name as client resource?

37 Posts

October 24th, 2016 06:00

Hi Hrvoje,

yes, I have a Cluster client ressource.

Regards

Heiko

53 Posts

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.

53 Posts

October 26th, 2016 03:00

MSSQLSERVER is for a default instance.  Pls. check whether the AG db's are configured with Named instance.

37 Posts

October 26th, 2016 03:00

Server instance is "MSSQLSERVER" which is Standard I think.

Regards

Heiko

37 Posts

October 26th, 2016 05:00

In the properties of the AG there is no instance defined.

37 Posts

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

53 Posts

October 26th, 2016 05:00

Can you post the screen shot of AG properties (using Primary replica)?

37 Posts

October 26th, 2016 07:00

Cluser nodes are "dghams200" and "dghams201". AO Cluster is "dghams203".

37 Posts

October 26th, 2016 07:00

SQL AO 2.JPG.jpg

37 Posts

October 26th, 2016 07:00

SQL AO.JPG.jpg

53 Posts

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....

No Events found!

Top