Unsolved
This post is more than 5 years old
14 Posts
0
31994
May 3rd, 2013 01:00
SQL 2012 AlwaysON Availability Groups Backup with NMM 2.4
Hi there
Wee need to backup Databases on a SQL 2012 Always On Availability Group.
With NMM 2.4, the Availability Groups from SQL 2012 are supported, but i can 't find a Dokumentation for setup the backup.
We use following Products:
Database Server:SQL2012 Enterprise Edition
OS: Windows 2008R
Hypervisor: VMWARE vSPhere 5.1
I installed the NMM 2.4 Client on the VM's and try to backup the model Database.
Save set: MSSQL:model
We configured the Networker Client with the following command:
nsrsqlsv -A Servername
Theres a error when i do the backup:
43708:(pid 2688):Start time: Fri May 03 09:55:04 2013
43621:(pid 2688):Computer Name: Servername User Name: SYSTEM
29100:(pid 2688): Invalid SQL virtual server name servername
38563:(pid 2688): Invalid option -A
37758:(pid 2688): Usage: nsrsqlsv [ ] {path}
options: [-CGjqRTvkuHXZ] [-s server] [-N name] [-b pool] [-g group]
[-S count] [-l level] [-m masquerade] [-U user [-P passwd]]
[[-A virtual-server] | [-c client]] [-a device interface=data domain] [-f aes] [-w browse] [-y retention]
[[-A virtual-server] | [-c client]] [-a De-duplication backup=yes] [-a De-duplication node= ] [-a De-duplication client name= ] [-f aes] [-w browse] [-y retention]
path: d-path | i-path
d-path: MSSQL: | [MSSQL:]s-path [[MSSQL:]s-path [...]]
i-path: MSSQL$inst-name: | MSSQL$inst-name:s-path [...]
s-path: database | database. | database.filegroup |
database.filegroup. | database.filegroup.file
43709:(pid 2688):Stop time: Fri May 03 09:55:04 2013
srv00801.intmain.introot.bkw-fmb.ch:MSSQL:model: No full backups of this save set were found in the media database; performing a full backup
srv00801.intmain.introot.bkw-fmb.ch:MSSQL:model: retried 1 times.
Is there somewhere a step by step Dokumentation how we can configure SQL2012 Backups ?
Umraan
96 Posts
0
May 29th, 2013 01:00
Hi
I have got the same setup as he has stated above and the same version of SQL and NMM 2.4
My backups and restores are completing successfully and I do not have the –A option
The error above states:
29100:(pid 2688): Invalid SQL virtual server name servername
38563:(pid 2688): Invalid option –A
Try running the backup without the –A option and also try with just the MSSQL: saveset
The error also points out issues with the credentials
If the backup still fails without the –A option then perhaps try small letter –a
Regards
Umraan
CarlosRojas
1.7K Posts
0
May 29th, 2013 02:00
Hi Sasha,
The "requires elevation" message is a clear indication of permissions problem, most likely because UAC is enabled on the SQL server. If so please disable UAC (requires reboot).
If UAC is disabled, please check the user set in remote user and password in the SQL client configuration in NMC, needs to be a SQL admin user.
Also ensure that you have the correct user in remote access field, and that same user is added in the correct groups in NMC under user/groups.
Thank you,
Carlos
obesa
14 Posts
0
May 29th, 2013 02:00
Hello Carlos
I triede your solution, didn’t work either.
Here the Error :
Cannot run savefs: The requested operation requires elevation.
Testserver.domaintest.ch:savefs: retried 1 times.
Which rights needs the Remote User where I need to configure in the Networker Console ?
Von: CarlosRojas
Gesendet: Mittwoch, 29. Mai 2013 09:51
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
CarlosRojas
1.7K Posts
0
May 29th, 2013 03:00
Try without -A (don't think it will work), but don't try with -a, as -a in NMM indicates device interface options, so that will fail for sure with message indicating a wrong command usage.
Thank you,
Carlos
Umraan
96 Posts
0
May 29th, 2013 03:00
Have you tried my option ?
Give it a try and see if it works or not…..
Regards
Umraan
CarlosRojas
1.7K Posts
0
May 29th, 2013 04:00
Umraan,
Do you have also configured Availability Groups in SQL 2012?
If so, have you tested any restore?
Thank you,
Carlos
CarlosRojas
1.7K Posts
0
May 29th, 2013 04:00
Sasha,
Actually Uraam was right, there is no need to set -A virtual name in this case.
Are you backing up primary or secondary replicas?
Please note the following:
For NMM 2.4 SP1 to perform backup of secondary replicas, the “Readable Secondary” option of SQL Server 2012 AlwaysOn configuration must be set to “Yes.” Enable this option for both primary and secondary replicas, as in case of failover of the availability group, secondary replicas become primary and vice versa.
Also ensure that you have set the correct users in the remote access field of the SQL server clients in NMC.
For testing purposes you can add *@* in both nodes.
Thakn you,
Carlos
Umraan
96 Posts
0
May 29th, 2013 04:00
Yes and yes have tested backups and restores
We backed up C1 SQL2012 and restored to C2 SQL2012 with NMM 2.4
Regards
Umraan
Umraan
96 Posts
0
May 29th, 2013 04:00
Ok try backup without –A then….mine works fine with just the nsrsqlsv command
Regards
Umraan
obesa
14 Posts
0
May 29th, 2013 04:00
Do you backup Databases in the SQL Always ON Availability Groups or just a Standalone ?
Von: Umraan
Gesendet: Mittwoch, 29. Mai 2013 13:18
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 Umraan in NetWorker Support Forum - View the full discussion
obesa
14 Posts
0
May 29th, 2013 04:00
I tried with just the command nsrsqlsv. The Remote User is sysadmin on the SQL Server and local User on the Windows System.
I just try to backup a System Database, model.
Disabled UAC.
I got now this error:
Cannot run savefs: A required privilege is not held by the client.
srv01537.intmain.introot.bkw-fmb.ch:savefs: retried 1 times.
Von: Umraan
Gesendet: Mittwoch, 29. Mai 2013 13:25
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 Umraan in NetWorker Support Forum - View the full discussion
Umraan
96 Posts
0
May 29th, 2013 04:00
Check if the account you are using is perhaps not locked out
And do you put the domain name in front of the account (domain\backupuser)
Regards
Umraan
Umraan
96 Posts
0
May 29th, 2013 04:00
SQL “AlwaysOn”
Regards
Umraan
obesa
14 Posts
0
May 29th, 2013 04:00
The SQL Server is not configured on the Standart Port, and its not a default instance. Could this be a problem ?
Von: Umraan
Gesendet: Mittwoch, 29. Mai 2013 13:25
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 Umraan in NetWorker Support Forum - View the full discussion
Umraan
96 Posts
0
May 29th, 2013 04:00
I just added the –A to one of my SQL 2012 clients and it failed with the same error that you getting
So I would suggest removing it…
3708:(pid 344):Start time: Wed May 29 13:12:08 2013
43621:(pid 344):Computer Name: SQL2012client User Name: backupuser
29100:(pid 344): Invalid SQL virtual server name zdc1frqc1.avinet.co.za
38563:(pid 344): Invalid option -A
37758:(pid 344): Usage: nsrsqlsv []
options:
[-U user ]
[[-A virtual-server] | ]
[[-A virtual-server] | ] [-a De-duplication node=]
path: d-path | i-path
d-path: MSSQL: | s-path [[MSSQL:]s-path ]
i-path: MSSQL$inst-name: | MSSQL$inst-name:s-path
s-path: database | database. | database.filegroup |
database.filegroup. | database.filegroup.file
43709:(pid 344):Stop time: Wed May 29 13:12:08 2013
Regards
Umraan
From: Umraan January
Sent: Wednesday, May 29, 2013 1:02 PM
To: 'jive-715757234-1zke-2-fqzv@emc-ecn.hosted.jivesoftware.com'
Subject: RE: - SQL 2012 AlwaysON Availability Groups Backup with NMM 2.4
Ok try backup without –A then….mine works fine with just the nsrsqlsv command
Regards
Umraan