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

Finalizing and submitting an Online VDI restore job

The final steps include setting additional options on the Schedule, Source Options, and Advanced Options pages, submitting the job, and monitoring the job’s progress. You can monitor progress by using the Job Status and View Logs pages. These pages and options are common to all NetVault Backup Plug-ins. For more information, see the Quest NetVault Backup Administrator’s Guide.

1
Click OK to save the settings, and then click Next.
2
In Job Name, specify a name for the job if you do not want to use the default setting.
Assign a descriptive name that lets you easily identify the job for monitoring its progress. The job name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Linux, the name can have a maximum of 200 characters. On Windows, there is no length restriction; however, a maximum of 40 characters is recommended.
3
In the Target Client list, select the machine on which you want to restore the data.
 
* 
TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box.
4
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options.
5
Click Save or Save & Submit, whichever is applicable.
You can monitor progress on the Job Status page and view the logs on the View Logs page. For more information, see the Quest NetVault Backup Administrator’s Guide.

Restoring data from VSS backups

The Microsoft VSS restore process includes the steps outlined in the following topics:

•
Selecting data for a VSS restore
•
Setting VSS restore options
•
Finalizing and submitting a VSS restore job
 
* 
IMPORTANT: The SQL Server Instance must be stopped when restoring the master database.

Selecting data for a VSS restore

1
In the Navigation pane, click Create Restore Job.
2
On the Create Restore Job — Choose Saveset page, select Plug‑in for SQL Server from the Plugin Type list.
3
To filter the items displayed in the saveset table further, use the Client, Date, and Job ID lists.
The table displays the saveset name (job title and saveset ID), creation date and time, and size. By default, the list is sorted alphabetically by saveset name.
The following table outlines the backup-type identifiers:
 
Backup type
Backup type identifier

Full Database

VSS FULL

Differential Database

VSS DIFFERENTIAL

Copy-Only

VSS COPY-ONLY

4
In the saveset table, select the applicable item.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, job title, server name, client name, plug-in name, saveset date and time, retirement setting, Incremental Backup or not, Archive or not, saveset size, and snapshot-based backup or not.
5
Click Next.
6
On the Create Selection Set page, select the applicable instance or the database for inclusion in the restore procedure.
Although you can double-click a node to open it and display the database name, and further drill-down shows items, you cannot select them.
7
If you are restoring data from a persistent snapshot, skip to Finalizing and submitting a VSS restore job.
To restore data from a persistent snapshot, no additional steps are required before you submit the job. After you submit the job, the plug-in automatically obtains the snapshot information from the backup index. If the snapshot is available, the plug-in mounts it locally and restores the selected files from the snapshot. If the snapshot is unavailable, the plug-in restores the file data from the storage media.

Setting VSS restore options

On the Create Selection Set page, click Edit Plugin Options, and configure the following parameters — these options are available for all VSS backup types:

•
Backup Method: This field displays the backup method used for the selected saveset.
•
Backup Type: This field displays the type of backup used for the selected saveset.
•
Restore Method: Select one of the following options:
•
VSS Restore: Select this option if to complete a restore to the same machine from which the backup was created.
•
Copy Database Files to Target Directory: Select this option to restore database files to a specified location. You can specify a directory on the local machine where the backups were taken. You can also specify a directory on any machine that has NetVault Backup and the plug-in installed and is reachable from the NetVault Backup Server, even if the machine does not have SQL Server installed. To restore a VSS backup to a different machine, use the Target Client list to select the NetVault Backup Client of the corresponding target machine.
 
* 
IMPORTANT: Because the maximum path length in Windows is 260 characters, check that the combination of the filenames and target path does not exceed 260 characters; otherwise, the restore fails.

If the backup contains FILESTREAM data, the restore process does not retain folder structure; the plug-in restores all files to the same folder. Because the folder structure of the database is not recreated, a file-activation error appears if you try to access the database. To avoid this issue, restore the backup to the original location.
•
Restore Type: This section lets you specify the action that must be performed after the restore operation. You can select from the following options:
•
With RECOVERY: Select this option if you do not intend to apply additional Transaction Log or Differential Database backups after the restore of the selected data has completed.
•
With NO RECOVERY: Select this option if you intend to apply a different Transaction Log or Differential Database backup after this restore has completed.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating