This post is more than 5 years old
4 Posts
0
4378
Networker Backup for clustered MSSQL fails
Hello all,
here you are my problem. Any help appreciated, thansk in advance.
Clustered SQL Server backup fails with error: "Invalid SQL virtual server name optype=pit"
Scenario:
--------------
Client: Windows 2008 R2 Enterprise SP1 - 2 node cluster - MS SQL Server 2008 R2 (SP3) default instance
NetWorker Module for Microsoft Applications version 2.4.0.375
Server: Windows 2008 R2 Enterprise SP1 - 2 node cluster
Networker server version 8.0.0.6 build 224
Client configuration on NMM:
General:
Name: SQLVirtualServer.mydomain.local
Save set: MSSQL:
Pool: SQL-CLU
Apps & Modules:
Remote user: mydomain\Administrator
Password: pwd
Backup command: nsrsqlsv -a SQLVirtualServer
Globals (1 of 2):
Aliases: SQLVirtualServer
SQLVirtualServer.mydomain.local
Globals (2 of 2):
Remote access: *@CLUSTERNODE1
*@CLUSTERNODE2
Storage Nodes: nsrserverhost
Recover Storage Nodes: nsrserverhost
The Problem:
--------------------
MSSQL:: NSRSNAPCK::success
MSSQL:: Backup of [MSSQL:] failed
52051:nsrsnap:Printing savecmd=nsrsqlsv after parsing
79549:nsrsnap:[nsrsnap.c 3316] Invoking command: "nsrsqlsv -A optype=pit -A pit_recycle_interval=86400 -A "pit_backup_pool=SQL-CLU" -A
NSR_PARENT_JOBID=1408029 -b SQL-CLU -c SQLVirtualServer.mydomain.local -g "SQL-CLU" -LL -m SQLVirtualServer.mydomain.local -s BACKUPSERVER -a "DIRECT_ACCESS=No" -l full -q -W 78 -a SQLVirtualServer -A "*crname=MSSQL:" -N "MSSQL:" -A snap_sessionid=1424192199 -A NSR_STRICT_SYNC=0 "MSSQL:
43708:(pid 2480):Start time: Tue Feb 17 17:56:59 2015
43621:(pid 2480):Computer Name: CLUSTERNODE1 User Name: Administrator
29100:(pid 2480): Invalid SQL virtual server name optype=pit
38563:(pid 2480): Invalid option -A
37758:(pid 2480): 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 2480):Stop time: Tue Feb 17 17:57:01 2015
Tests completed:
--------------------------
1) savegrp -D1vvv -c SQLVirtualServer.mydomain.local SQL-CLU
RPC Authentication: error in LookupAccountSid: No such file or directory
3:savegrp: Group SQL-CLU waiting for 1 jobs to complete
90494:savegrp: SQLVirtualServer.mydomain.local unexpectedly exited.
83647:savegrp: SQL-CLU SQLVirtualServer.mydomain.local:MSSQL: See the file C:\Program Files\EMC NetWorker\nsr\logs\sg\SQL-CLU\1408051 for command output
7241:savegrp: nsrim run recently, skipping
C:\Program Files\EMC NetWorker\nsr\logs\sg\SQL-CLU\1408051 content:
52051:nsrsnap:Printing savecmd=nsrsqlsv after parsing
79549:nsrsnap:[nsrsnap.c 3316] Invoking command: "nsrsqlsv -A optype=pit -A pit_recycle_interval=86400 -A "pit_backup_pool=SQL-CLU" -A
NSR_PARENT_JOBID=1408049 -b SQL-CLU -c SQLVirtualServer.mydomain.local -g "SQL-CLU" -LL -m SQLVirtualServer.mydomain.local -s BACKUPSERVER -a
"DIRECT_ACCESS=No" -l full -q -W 78 -a SQLVirtualServer -A "*crname=MSSQL:" -N "MSSQL:" -A snap_sessionid=1424195594 -A NSR_STRICT_SYNC=0 "MSSQL: MSSQL::
NSRSNAPCK::success43708:(pid 4348):Start time: Tue Feb 17 18:53:33 201543621:(pid 4348):Computer Name: CLUSTERNODE1 User Name: Administrator29100:(pid 4348): Invalid SQL virtual server name optype=pit38563:(pid 4348): Invalid option -A37758:(pid 4348): 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-pathd-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.file43709:(pid 4348):Stop time: Tue Feb 17 18:53:36 2015MSSQL:: Backup of [MSSQL:] failed
2) Backup completes with no errors if executed using NMM Application directly on client
3) Name resolution is OK
crazyrov
4 Operator
4 Operator
•
1.3K Posts
0
February 18th, 2015 07:00
When you use the command "nsrsqlsv" you are doing a VDI based SQL backup. Snapshot should be enabled only when you are doing a VSS based SQL backup.
Go though the NMM admin guide for more details.
CarlosRojas
1.7K Posts
0
February 18th, 2015 02:00
The configuration is wrong,
In the backup command you need to use -A SQL_VIRTUAL_NAME not -a
Thank you,
Carlos
crazyrov
4 Operator
4 Operator
•
1.3K Posts
0
February 18th, 2015 02:00
What version is your backup server on ? Are you using a named instance or the default SQL instance ?
Ensure you have not disabled "client direct" on the client properties.
frossi99992
4 Posts
0
February 18th, 2015 02:00
Thanks for answerring.
@crazyrov: Networker server version 8.0.0.6 build 224. I tried either enabling or disbling "client direct" option with same results.
@Carlos: I have the same results with uppercase and lowercase option "-A". Will use only "-A" from now on.
crazyrov
4 Operator
4 Operator
•
1.3K Posts
1
February 18th, 2015 03:00
Have you enabled snapshot on the group, if yes disable that and give it another shot.
frossi99992
4 Posts
0
February 18th, 2015 05:00
Hi crazyrov, it works this way!
But now I am confused: why cannot snapshots be used and what kind of backup am I doing now?
Thanks a lot.
frossi99992
4 Posts
0
February 18th, 2015 07:00
:-O thanks a lot!
Regards,
Francesco.