Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 12.2 - User Guide

Introducing NetVault Backup Plug-in for SQL Server Planning your SQL Server deployment Installing and removing the plug-in Configuring the plug-in Backing up data
Defining a backup strategy Understanding snapshot-based backups Reviewing the compression features Performing Online VDI backups Performing VSS backups in SQL Server Example of creating a full VDI backup of an AlwaysOn Availability Group on Windows
Restoring data Using the CLI with the plug-in Troubleshooting

About the NetVault Backup CLI

NetVault Backup offers a Command Line Interface (CLI) that you can use to configure and manage your NetVault Backup system from a command prompt or terminal session. You can use the NetVault Backup CLI to perform various tasks such as the following:

•
Start and stop the NetVault Backup Service.
•
Manage clients, storage devices, and storage media.
•
Perform backups and restores.
•
Generate and view reports.

You can access the NetVault Backup CLI can be accessed from the NetVault Backup Server and Client machines. For more information about the command-line utilities, see the Quest NetVault Backup CLI Reference Guide.

Performing tasks using the CLI

You can use the job-specific CLI utilities to perform the following tasks:

•
Creating a selection set
•
Creating an option set
•
Submitting a backup job
•
Restoring a job
•
Example of using the NetVault Backup CLI to create a Full Database backup for VSS

Creating a selection set

You can create a selection set using the nvsetcreate CLI utility.

Syntax
nvsetcreate [-setname <setName> ‑type <setType> <setTypeSpecificOptions> ‑parameters <parameterFilename> ‑assign <assignmentCharacter> ‑delimit <delimiterCharacter> ]
Example

To create a Backup Selection Set called backup_set1 that uses the Backup Selections type, BS, on a NetVault Backup Client named SQL_Server_Client and include all instances from the plug-in, enter the following:

nvsetcreate.exe -setname backup_set1 -type BS -client SQL_Server_Client -plugin "Plug-in for SQL Server" -include "All Instances"

Creating an option set

You can create an option set using the nvsetcreate utility. Alternatively, you can specify job-specific options while running the nvjobcreate utility. You can specify options by using the -backupoption tag with the nvsetcreate or nvjobcreate utilities.

The following table shows some examples of using this tag with the nvsetcreate utility:

 
Table 1. Examples
Example
Usage

nvsetcreate.exe ‑setname vss-option-set ‑type BO ‑client SQL_Server_Client ‑plugin "Plug-in for SQL Server" ‑backupoption MSSQL_OPT_USE_VSS=TRUE

Creates an option set with VSS backup method.

nvsetcreate.exe ‑setname full-backup-set ‑type BO ‑client SQL_Server_Client ‑plugin "Plug-in for SQL Server" ‑backupoption MSSQL_OPT_TYPE_FULL=TRUE

Creates an option set with FULL backup type.

nvsetcreate.exe ‑setname differential-backup-set ‑type BO ‑client SQL_Server_Client ‑plugin "Plug-in for SQL Server" ‑backupoption MSSQL_OPT_TYPE_DIFF=TRUE

Creates an option set with DIFFERENTIAL backup type.

The following table shows the commonly used IDs for the -backupoption tag.

 
Table 2. List of commonly used IDs for -backupoption tag
Tag
Tag ID
Description

MSSQL_OPT_TYPE_FULL

101

Creates a backup job using the Full Database backup type.

MSSQL_OPT_TYPE_DIFF

102

Creates a backup job using the Differential Database backup type.

MSSQL_OPT_TYPE_COPY_ONLY

115

Creates a backup job using the Copy-Only backup type.

MSSQL_OPT_USE_VDI

302

Selects the VDI backup method.

MSSQL_OPT_USE_VSS

305

Selects the VSS backup method.

MSSQL_VDI_TRANSFER_SIZE

402

Specifies the transfer size for a VDI backup job.

SQLSERVER_VDI_BLOCK_SIZE

408

Specifies the block size in bytes for a VDI backup job.

MSSQL_OPT_TYPE_VSS_FULL

409

Creates a VSS backup job using the Full Database backup type.

MSSQL_OPT_TYPE_VSS_DIFF

410

Creates a VSS backup job using the Differential Database backup type.

MSSQL_OPT_TYPE_VSS_COPY_ONLY

411

Creates a VSS backup job using the Copy-Only backup type.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating