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

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

1
Next to the Plugin Options list, click Create New.
2
In the Backup Method section, select Use Virtual Device Interface (VDI).
3
In the Backup Type section, select Full Database.
4
In the Incomplete Backup of ALL Items Selected section, select the applicable option.
5
In the VDI Backup Options section, select the applicable compression.
6
Complete the VDI Streams/Compression Threads and Number of Parallel NetVault Backup Streams options.
 
* 
NOTE: In an AlwaysOn Availability Group, the plug-in uses Number of Parallel NetVault Backup Streams as the number of streams used by each NetVault Backup Client. For example, if the group has three NetVault Backup Clients, and you enter 1 for the number of streams, each uses one stream. This specification equals three streams for the overall backup job.
7
If you want the plug-in to perform checksum on the backups, select the Enable Backup Checksum option, and then use Error Encountered During Checksum to indicate what the plug-in should do if it encounters an error.
8
Click the AlwaysOn Availability Groups tab, and select the Primary Only option.
9
Click Save, specify a name for the set in the Create New Set dialog box, and click Save.

Finalizing and submitting a full VDI backup job of an AlwaysOn Availability Group

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.
 

Restoring data

•
Restoring data: an overview
•
Restoring data from Online VDI backups
•
Restoring data from VSS backups
•
Using other restore procedures

Restoring data: an overview

Restoring is the process of copying data from a backup and applying transaction logs to the data to roll it forward to the target recovery point. A backup contains sufficient transaction log records to allow rolling forward the active transactions as part of restoring each backup. Each backup also contains sufficient transaction logs to roll back any uncommitted transactions to bring the database to a consistent, usable state. The process of rolling forward uncommitted transactions, if any, and bringing the database online is known as Recovery.

Understanding the Online VDI restore process

This topic includes the following subtopics:

•
Reviewing the phases of the VDI restore sequence
•
Understanding the available types of Online VDI restores
•
Restoring system databases for Online VDI restore with Plug‑in for SQL Server
•
Restoring databases involved in replication for Online VDI restore
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating