SQL 2012 AlwaysON Availability Groups Backup with NMM 2.4

For the beginning, i just try to backup the system databases. They are not in a Availabiltiy Group.

Von: CarlosRojas

Gesendet: Mittwoch, 29. Mai 2013 13:53

An: Oberhofer Sascha, FD ICT/IEO/IEN/DBE

Betreff: Re: - SQL 2012 AlwaysON Availability Groups Backup with NMM 2.4

ECN

SQL 2012 AlwaysON Availability Groups Backup with NMM 2.4

reply from CarlosRojas in NetWorker Support Forum - View the full discussion

Umraan, can you please check on which account runs the service „NetWorker Remote Exec Service” on your SQL Server ?

If you are an administrator on the client server then try testing with your own admin account

And don’t specify a database, use the MSSQL: save set to test if all backups fail or succeed

Regards

Umraan

Can you try and run the backup from the client side using the NMSQL gui and see what happens

Also check if both servers can see each other, do a reverse lookup from both ends

Regards

Umraan

If i run with Remote Access User configured, there is this error:

Cannot run savefs: A required privilege is not held by the client.

srv01536.intmain.introot.bkw-fmb.ch:savefs: retried 1 times.

If I left this field blank, it take longer to the error:

43708:(pid 4700):Start time: Wed May 29 15:16:25 2013

43621:(pid 4700):Computer Name: Testserver User Name: d_serviceaccount

29085:(pid 4700):Microsoft SQL Server Provider error:

38006:(pid 4700):Named Pipes Provider: Could not open a connection to SQL Server . .

38006:(pid 4700):A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

38006:(pid 4700):Login timeout expired.

67945:(pid 4700):Cannot login to SQL Server Default Instance.

43709:(pid 4700):Stop time: Wed May 29 15:16:37 2013

srv01536.intmain.introot.bkw-fmb.ch:MSSQL:master: No full backups of this save set were found in the media database; performing a full backup

srv01536.intmain.introot.bkw-fmb.ch:MSSQL:master: retried 1 times.

With the GUI, i can Select the database, when I try e backup theres an error:

“The Program could not be started. It may not be in the Networker Directory. Make sure you have installed Networker correctly.”

Ok then try to uninstall NMM 2.4 and NetWorker and then re-install NetWorker and NMM again

Also do you Have a NMM or NMSQL license to backup the database ?

Regards

Umraan

I did not see that last error you posted. - 38006:(pid 4700):Named Pipes Provider: Could not open a connection to SQL Server .

I’ve seen that error before and in most cases SQL is not online, please check if all SQL instances are online – then retry the backup

Regards

Umraan

obesa,

I had a similar issue when I set up our SQL2012 DAG environment.

You cannot use the remote user field as it will not get passed correctly.

Change the Log On of the nsrexecd service to an account with SQL SA permissions and Admin rights on the box.  This will allow the backups to run.  The only issue I have seen from this in my environment is that because or group policies I need to re-enter the password to bring up the service after a reboot.

-Gary

Dear Carlos,

I am using networker server 8.0.2.6 and client has nsr 8.0.3.2 with win2k8 R2, NMM 2.4.1 build192, SQL 2012.

The server is in DMZ zone, ports 7936-9936 are open bi-directionally, I am trying to backup SQL2012 from the server but is failing, file level backup via snapshot is working fine, backup taken by NMSQL from client side is also working fine, but it is giving error when it is scheduled from the server ' Cannot run savefs: The requested operation requires elevation.' Please note I have mentioned the username and password as required for SQL 2012 client resource.

While searching for the related errors on the forum I came across your post, I ran the savegrp command as suggested and below is the output, could you please suggest what is going wrong.

C:\Windows\system32>savegrp -D1vvv -c client group
RPC Authentication: error in LookupAccountSid: No such file or directory
3:savegrp: Added 'server' to the group 'group'
for bootstrap backup
84078:savegrp: command 'savefs -s server -c client
-g group -p -l full -R -v -F MSSQL:' for client client exited with retur
n code 76
90491:savegrp: client:savefs unexpectedly exited.
90492:savegrp: client:savefs will retry 1 more time(s).
83647:savegrp: group client:savefs See the file E:\Program Files\EMC Net
worker\nsr\logs\sg\group\34375 for command output
Job 34375 received multiple and conflicting compattrs, old:2, new:1
3:savegrp: Group group waiting for 1 jobs (1 awaiting restart) to complete
.

84078:savegrp: command 'savefs -s server -c client
-g group -p -l full -R -v -F MSSQL:' for client exited with retur
n code 76
90491:savegrp: client:savefs unexpectedly exited.
83647:savegrp: group client:savefs See the file E:\Program Files\EMC Net
worker\nsr\logs\sg\group\34376 for command output
Job 34376 received multiple and conflicting compattrs, old:2, new:1
89713:savegrp: The save set client:MSSQL: abandoned because of savefs probe fa
ilure.

77562:savegrp: job (34377) host: client savepoint: MSSQL: had ERROR indication
(s) at completion
90491:savegrp: client:MSSQL: abandoned.
3:savegrp: Group waiting for 1 jobs (0 awaiting restart) to complete
.

7241:savegrp: nsrim run recently, skipping

C:\Users\aagrawaa> savefs -s server -c client -g group -p -l full -R -v -F MSSQL:

type: NSR client description;

pools supported: Yes;

browse time supported: Yes;

multiple balanced streams supported: Yes;

remote user: user;

groups: Domain Users, Everyone, Users, Remote Desktop Users, REMOTE INTERACTIVE

LOGON, Authenticated Users, This Organization,

;

arch: Windows Server 2008 R2;

client OS type: Windows NT Server on Intel;

CPU type: AMD_X8664;

CPUs: 32;

kernel arch: AMD_X8664;

machine type: server;

MB used: 177619;

NetWorker version: 8.0.2.6.Build.273;

OS: Windows Server 2008 R2 6.1;

version: 8.0.2.6.Build.273;

save set: path="MSSQL:", arg="MSSQL:", level=full, diskno=0, max_sessions=1, sty

pe=save ;

checkpoint restart capable: Yes;

parallelism: 4

savefs client: succeeded.

nsr\logs\sg - " Cannot run savefs: The requested operation requires elevation"

Please note the backup account is a domain admin, local admin, sysadmin for SQL DB, backup runs fine from client side.

Regards

tech88kur

Did you try to disable UAC?

I just tried with changing the logon accounts of nsrexecd and nsrpsd from 'local system' to a account which has local admin and domain admin privilege, this time the error was 'Cannot run savefs: A required privilege is not held by the client'.

Next I am going to disable UAC, i am scheduling the restart......i will keep you posted.

One quick question - why is UAC not affecting client-initiated NMSQL backups ?

Regards

tech88kur

Hrvjoe,

Yes, I missed disabling UAC but the I am able to take backups via NMSQL on clinet.

In addition to that I will also try changing the log on account and then see what happens next.

Regards

tech88kur

When you run client initiated backup, are you logged as user running services?  The error itself seems to indicate UAC thingy so it is worth trying.