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:

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

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

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

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:

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

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.

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