hi, buddy

what about this case ?

I didn't get to the bottom of this, but I suspect for this to work I need to create AD user and use that user for backup instead. I was on longer vacation so I left this as it is.  Not sure how others are doing it so perhaps someone who already did it can share some details.

thanks 

I search many resource and suspect that we need disable "UAC" then everything is OK

UAC handles user logins (actually, it handles permissions for execution) at OS level; this is error with login at SQL error so I think it is not related.

buddy

I just want to backup MSSQL on primary node at  always on enviroument, I try  time but failed

maybe it really  UAC problem

The error I showed was from secondary node replica  - not primary one.  Which error do you get?

Neither primary one or secondary one . 

I did not success on both of them

How do you  do backup it successful on primary node ?

I define save set and run backup - nothing special there.  Once again, what is the error you get?

dear 

     my enviroument is two active node & one passive node just for fail over (not read only)..

I make the save set as

MSSQL:MESP1

then I get  error

3708:(pid 6184):Start time: Mon Aug 24 16:17:44 2015

43621:(pid 6184):Computer Name: LCHDMESPNB41     User Name: SYSTEM

97546:(pid 6184):Back up of MESP will be excluded as it is part of Availability group. It can be backed up using SQL federated workflow.

29211:(pid 6184):At least 1 valid backup target is required

43709:(pid 6184):Stop time: Mon Aug 24 16:19:48 2015

Unable to find any full backups of the save set 'LCHDMESPNB41:MSSQL:MESP' in the media database. Performing a full backup.

LCHDMESPNB41:MSSQL:MESP: retried 1 times.

Please check VDI SQL admin guide - you will see that for AG backup, you must use slightly different name of save set (where with # you specify AG name).

hi  buddy

do you mean I need to follow this ?

• In the Save Set attribute, specify the components to be backed up:
• AlwaysOn Group referring SQL default instance — MSSQL#AG1
• AlwaysOn Group referring SQL default instance — MSSQL#AG1:Database1
• AlwaysOn Group referring SQL named instance — MSSQL$NamedInstance#AG2
• AlwaysOn Group referring SQL named instance — MSSQL$NamedInstance#AG2:Database2

thanks

this is my network & module version

NetWorker Management Console 8.2.1.0.Build.681

NetWorker Module for Microsoft(R)SQL Server version 3.0.1.2.280

Is it right version ?

Yes, naming convention for save set should be as listed.  As for NMM module, you should use NMM 8.2.1.6 or NMM 3.0.1.3.