群集 SQL Server 实例中 nsrsqlsv 的 NetWorker Module for Microsoft 命令行语法

本文介绍如何使用 VDI 命令行语法或 nsrsqlsv 通过 NetWorker Module for Microsoft 备份虚拟（群集）SQL Server 实例。

以下是命令行语法无法执行手动备份时的典型消息：

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

使用 nsrsqlsv 备份群集 SQL Server 实例需要特定参数。

最重要的两个要求：

• 用途：

-A virtualservername

• 省略实例名称：

MSSQL:  Save Set name cannot include $instance name

• 对于 SQL Server 的任何 群集实例 ：

$instance name from MSSQL:

nsrsqlsv -A SQL_virtual_server_name -c SQL_virtual_server_name -s NetWorker_server_name MSSQL:

• 对于任何 SQL Server 的非群集实例 ：

$instance name with MSSQL$instance name:

-A as it is not clustered:

nsrsqlsv -c SQL_virtual_server_name -s NetWorker_server_name MSSQL$instancename:

示例：

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