NetWorker Module for Microsoft Command-line Syntax for nsrsqlsv in Cluster SQL Server Instance

Summary: How to backup Virtual (Clustered) SQL Server instance with NetWorker Module for Microsoft using VDI command-line syntax or 'nsrsqlsv'

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

This article describes how to backup Virtual (Clustered) SQL Server instance with NetWorker Module for Microsoft using VDI command-line syntax or nsrsqlsv.

Below is a typical message when command-line syntax fails to perform manual backup:

Command line syntax fails for  'nsrsqlsv'  when performing manual backup of a Clustered virtual SQL Server instance. 

Usage appears:  

37758:(pid 1712): Usage: nsrsqlsv [<options>] {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=<Avamar Node Name>] [-a De-duplication client name=<client>] [-f aes] [-w browse] [-y retention]
         [[-A virtual-server] | [-c client]] [-z FEDERATED_SLAVE=true]
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

Cause

Usage for nsrsqlsv to backup a clustered SQL Server instance requires specific parameters.

The two most important requirements:

  • Use of:
-A virtualservername
  • Omit instance name:
MSSQL:  Save Set name cannot include $instance name

Resolution

To backup SQL Server, using VDI with NetWorker Module for Microsoft when the client is a Clustered SQL Server instance requires the following adjustments:
  • For any clustered instance of SQL Server:
OMIT: 
$instance name from MSSQL:

nsrsqlsv -A SQL_virtual_server_name -c SQL_virtual_server_name -s NetWorker_server_name MSSQL:
  • For any nonclustered instance of SQL Server:
The save set INCLUDES: 
$instance name with MSSQL$instance name:
OMIT: 
-A as it is not clustered:

nsrsqlsv -c SQL_virtual_server_name -s NetWorker_server_name MSSQL$instancename:

Examples:

Virtual SQL Server name - This is the DNS name for SQL Server in a cluster. sqlvir1  
Clustered SQL Server instance name - This is the instance name created by SQL Server clustered installation, * is never used in syntax. PROD1
Standalone SQL Server hostname sqldb1
Standalone SQL Server instance name - This is the instance name created by SQL Server stand-alone installation, * is used in syntax. PROD
NetWorker Server bup1
Pool Default
  
Examples:

Example for Clustered SQL Server - nsrsqlsv syntax 
NOTE - OMIT instance name "PROD1" 

  nsrsqlsv -A sqlvir1  -c sqlvir1 -s bup1 b Default  MSSQL:
  nsrsqlsv -A sqlvir1  -c sqlvir1 -s bup1 b Default  MSSQL:dbname
  
  
Example for Standalone Server - nsrsqlsv syntax 
NOTE - OMIT -A   but include instance name PROD

  nsrsqlsv  -c sqldb1 -s bup1 -b Default  MSSQL$PROD:
  nsrsqlsv  -c sqldb1 -s bup1 -b Default  MSSQL$PROD:dbname
Article Properties
Article Number: 000015997
Article Type: Solution
Last Modified: 27 May 2024
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.