Tchater maintenant avec le support
Tchattez avec un ingénieur du support

NetVault Plug-in for SQL Server 10.0.6 - User Guide

Introducing Dell™ 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 Restoring data Troubleshooting

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

Defining a backup strategy

The purpose of creating SQL Server® backups is to recover a database that is damaged from media failure or data corruption. Reliable use of backup for recovery requires a strategy that maximizes data availability and minimizes data loss, taking into account defined business requirements.
A backup strategy is divided into two pieces: a backup piece and a restore piece.
•
The backup piece defines the type and frequency of backups that are required to meet the goals for availability of the database and for minimizing data loss.
•
The restore piece defines who is responsible for performing restores, and how restores should be performed to recover from the particular type of damage or failure.
 
* 
IMPORTANT: If you use Plug‑in for SQL Server, verify that you are not using a third-party program to complete additional backups of SQL Server. Otherwise, a conflict might occur during the restore or recovery process when the differential backups do not match.
For more information, review the following sections:
•
Reviewing the available backup methods
•
Reviewing SQL Server® recovery models
•
Defining an online VDI backup strategy and reviewing types
•
Examples of VDI online backup sequences
•
Defining a VSS backup strategy and reviewing types
•
Examples of VSS backup sequences
•
Backing up system databases
•
Backing up replicated databases

Reviewing the available backup methods

The plug-in offers the following backup methods:
•
Online Virtual Device Interface (VDI)
•
Volume Shadow Copy Service (VSS)
The plug-in supports implementing an Online VDI or a pure VSS backup strategy, not a combination of the two.

Online Virtual Device Interface (VDI)

Microsoft supports the ability to perform online backups that use the VDI Application Program Interface (API) to integrate with a range of backup devices supported by NetVault Backup. Online VDI backups provide maximum reliability and flexibility when defining a backup strategy. This method supports the full range of backup types and options available with SQL Server®’s Transact SQL language along with the ability to handle a number of recovery scenarios.
The backup-and-restore strategies available with the Online through VDI Backup Method are thoroughly discussed in the Backing Up and Restoring Databases section of the SQL Server Books Online.
Plug‑in for SQL Server’s Online through VDI backup method is the preferred backup method.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation