NetVault Plug-in for SQL Server 10.0.6

NetVault Plug-in for SQL Server 10.0.6 - User Guide

Introducing Dell™ NetVault™ Backup Plug-in for SQL Server®

•

Dell NetVault Backup Plug‑in for SQL Server: at a glance

•

Key benefits

•

Feature summary

•

Target audience

•

Dell NetVault Backup Plug-in for SQL Server: at a glance

The Dell NetVault Backup (NetVault Backup) Plug‑in for SQL Server (Plug‑in for SQL Server) increases confidence in recoverability of SQL Server® databases and eliminates the need for complex scripting. Through a web-based user interface (WebUI) and automated workflow process, the plug-in offers a centralized way to set up, configure, and define backup and restore policies. Support for Online Virtual Device Interface (VDI) and Volume Shadow Copy Service (VSS) backups lets you implement your preferred backup method, without requiring you to learn SQL Server internals. Plug‑in for SQL Server offers a detailed level of control, which lets you restore complete databases, partial databases, or individual data files, thus minimizing downtime. In addition, the plug-in supports SQL Server features such as Failover Clustering (Active/Passive), AlwaysOn Availability Groups (SQL Server 2012 and later), and Transparent Data Encryption (TDE).

Through integration with a range of backup devices, your data is protected and stored offsite to meet your disaster-recovery and business-continuity goals.

Key benefits

•

Increase confidence when deploying the plug-in: With Plug‑in for SQL Server, you do not have to worry about learning SQL Server internals before implementing a backup policy that accounts for many recovery scenarios. You can choose the best method for the job. You might choose VDI, which provides maximum reliability and performance while supporting the full range of SQL Server backup-and-restore functionality. You might choose Microsoft’s VSS framework, which lets you perform volume backups while applications on a system continue to write to the volumes, all without writing complex scripts.

Plug‑in for SQL Server’s backup features also include:

•

Protection for standalone and cluster environments

•

Online VDI- or VSS-based backups

•

Full and Differential Database backups while data is online and accessible

•

Incremental Transaction Log and Tail-Log backups (VDI only)

•

Copy-Only backups

•

Advanced Full and Differential File backups along with Partial Database and Differential Partial Database backups

•

Protection for Filestreams

•

Protection down to the datafile level

•

Backup-compression support

•

Creation of backup checksums that are used during restores to detect corruption

By relying on the plug-in to implement your backup policies, you can focus on more critical tasks without risking your ability to recover what is needed if a failure occurs. In addition, the IT manager’s confidence is increased by knowing that SQL Server data is protected.

•

Speed up restores to reduce downtime: Plug‑in for SQL Server empowers you to create a comprehensive and flexible backup policy and reduces the need for scripting, which may increase the risk of syntax or human errors. Select what needs to be restored, the backup set to restore from, and, if appropriate, the time or marked transaction restore point, and the plug-in performs recovery without further interaction.

Additional Plug‑in for SQL Server restore-and-recovery features include:

•

Full, differential, incremental, and time and marked transaction point-in-time (PIT) restores

•

Restores of complete databases, partial databases, or individual datafiles

•

Rename of datafiles

•

Restore VDI-based backups to an alternate server

•

Restore VDI-based backups from a clustered configuration to a standalone installation

•

Disaster recovery

•

Ensure business continuity: With offsite backups being an important part of the data-protection for business-critical applications, the plug-in takes advantage of NetVault Backup’s integration with a range of backup devices. NetVault Backup lets you select which backup device to store the backup on. You can store the backup online in a virtual tape library (VTL). You can also duplicate the job to physical tape libraries shared by multiple SQL Server databases, other proprietary databases, or used for backup.

Plug‑in for SQL Server gives you the confidence that your SQL Server environment is protected and stored offsite for disaster-recovery purposes. At the same time, it frees administrators from being present 24x7 as less-experienced personnel can initiate restores.