Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

4378

February 17th, 2015 10:00

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

4 Operator

 • 

1.3K Posts

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.

1.7K Posts

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

4 Operator

 • 

1.3K Posts

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.

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.

4 Operator

 • 

1.3K Posts

February 18th, 2015 03:00

Have you enabled snapshot on the group, if yes disable that and give it another shot.

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.

February 18th, 2015 07:00

:-O thanks a lot!

Regards,

Francesco.

No Events found!

Top