Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 11.2 - User Guide

Introducing Quest® 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 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
Restoring data Troubleshooting

Setting backup options for a VSS backup

The next step involves creating the Backup Options Set or selecting an existing one.

 
* 
TIP: To use an existing set, in the Plugin Options list, select the set that you want to use.
 
* 
NOTE: During a VSS backup, the plug-in ignores all new databases and performs only the differential backup of databases that have had a full VSS backup first. An error message indicating that this issue has occurred displays in the NetVault Backup log.
1
Next to the Plugin Options list, click Create New.
2
In the Backup Method section on the SQL Server Backup Options tab, select Use Volume Shadow Copy Services (VSS).
3
In the Backup type section, select the applicable option:
•
Full Database
•
Differential Database
•
Copy-Only
For information on these backup types, see Defining a VSS backup strategy and reviewing types.
4
In the VSS Backup Options section, select Use multiple snapshots to limit demands on system resources.
* 
NOTE: You must select the option Use multiple snapshots to limit demands on system resources for VSS Differential Database backup type if you selected it for VSS Full Database backup type.
NOTE: This option can be applied when 'VSS Backup Method' is selected. When a VSS snapshot is taken, the amount of system resources required increases with the amount of SQL Server databases that is included in the snapshot. Select this option to limit the amount of system resources that are used by the VSS snapshot. When this option is selected, the Plug-in for SQL Server, groups the selected databases in groups or batches, and takes a snapshot for each batch, instead of including all the selected databases in one single snapshot. Hence, system resources are not exhausted.
5
Click Save, enter a name in the Create New Set dialog box, and click Save.
The name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Windows®, there is no length restriction; however, a maximum of 40 characters is recommended.

Finalizing and submitting a VSS backup job

The final steps include setting additional options on the Schedule, Target Storage, and Advanced Options pages, submitting the job, and monitoring the 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
Use the Schedule, Target Storage, and Advanced Options lists to configure any additional required options.
2
Click Save or Save & Submit, whichever is applicable.
 
* 
TIP: To run a job that you have already created and saved, select Manage Job Definitions in the Navigation pane, select the applicable job, and click Run Now.
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.

Example of creating a full VDI backup of an AlwaysOn Availability Group

This procedure is based on the following configuration and settings:

•
The AlwaysOn databases reside on the primary replica and on all secondary replicas.
•
The Virtual Client uses the network name or IP address of either the AlwaysOn Availability Group Listener or the AlwaysOn Cluster.
•
The database is online.
•
All SQL Server services, including SQL Server Browser, are running on each node.
•
NetVault Backup Server is running only on the server; it is not running on the client nodes.
•
The Log on as option for the NetVault Process Manager is configured to use the domain administrator.
•
Each NetVault Backup client node is able to access the NetVault Backup client on the other nodes.

After reviewing the preceding information, complete the steps outlined in the following topics:

•
Creating a Backup Selection Set for a full VDI backup of an AlwaysOn Availability Group
•
Creating a Backup Options Set for a full VDI backup of an AlwaysOn Availability Group
•
Finalizing and submitting a full VDI backup job of an AlwaysOn Availability Group

Creating a Backup Selection Set for a fullVDI backup of an AlwaysOn Availability Group

1
In the Navigation pane, click Create Backup Job.
2
In Job Name, specify a name for the job.
3
Next to the Selections list, click Create New.
4
In the list of plug-ins for the applicable Client, open Plug‑in for SQL Server, and then open the All Instances node to view the individual instances.
5
Do either of the following:
•
Select an entire AlwaysOn Availability Group instance for inclusion.
•
Open an AlwaysOn Availability Group instance to display its individual databases, and select the databases that you want to include.
 
* 
IMPORTANT: If you are running a Tail-Log backup, use SQL Server Management Studio to remove the primary and secondary databases from the group before continuing. After the databases are removed from the group, their status changes to Restoring, and they are owned by the SQL Server Instance assigned the Primary Role in the group. To complete the Tail-Log backup, select the databases under the SQL Server Instance.
6
Click Save, enter a name in the Create New Set dialog box, and click Save.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating