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
Recommended additional reading
Planning your SQL Server deployment
Installing and removing the plug-in
Installation prerequisites
Configuring the plug-in
Prerequisites for a standalone deployment
Additional prerequisites for a high-availability deployment
Installing or upgrading the plug-in in a standalone environment
Installing or upgrading the plug-in in a high-availability environment
Licensing the plug-in
Removing the plug-in from a standalone deployment
Removing a SQL Server® Instance
Configuring authentication details
Configuring plug-in options
Entering logon credentials for all instances on a client
Entering default logon credentials for a specific SQL Server Instance
Enabling communication between nodes in an AlwaysOn Availability Group
Changing the TCP/IP port for SQL Server®
Setting up SQL Server® Authentication for SQL Server 2012 or later
Backing up data
Defining a backup strategy
Restoring data
Reviewing the available backup methods
Reviewing SQL Server® recovery models
Defining an Online VDI backup strategy and reviewing types
Reviewing the compression features
Performing Online VDI backups
Full Database backup for Online VDI
Differential Database backup for Online VDI
Copy-Only backup for Online VDI
Incremental Transaction Log backup for Online VDI
Tail-Log backup for Online VDI
Full File and Filegroup backup for Online VDI
Differential File and Filegroup backup for Online VDI
Partial Database backup for Online VDI
Differential Partial Database Backup for Online VDI
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
Selecting data for an Online VDI backup
Setting backup options for an Online VDI backup with Plug-in for SQL Server
Finalizing and submitting an Online VDI backup job
Performing VSS backups in SQL Server®
Selecting data for a VSS backup
Setting backup options for a VSS backup
Finalizing and submitting a VSS backup job
Example of creating a full VDI backup of an AlwaysOn Availability Group
Restoring data: an overview
Troubleshooting
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
Restoring data from Online VDI backups
Selecting Online VDI data for restore
Setting Online VDI restore options
Finalizing and submitting an Online VDI restore job
Restoring data from VSS backups
Selecting data for a VSS restore
Setting VSS restore options
Finalizing and submitting a VSS restore job
Using other restore procedures
Installing or upgrading the plug-in in a standalone environment
You can install or upgrade the plug-in on individual systems, one at a time. You can also deploy the plug-in to multiple machines by creating a deployment task from the WebUI to push the packages to the specified machines. You can use this method for both new and upgrade installations on Windows®-based machines. After the packages are installed on the machines, the new machines are automatically added to the NetVault Backup Server.
Performing a local installation
|
1 |
In the Navigation pane, click Manage Clients. |
|
2 |
|
3 |
).|
4 |
Click Choose Plug-in File, navigate to the location of the “.npk” installation file for the plug-in, for example, on the installation CD or the directory to which the file was downloaded from the website. |
|
5 |
Select the file entitled “sql-x-x-x-x.npk,” where xxxx represents the version number, and click Open. |
|
6 |
To begin installation, click Install Plugin. |
Performing a remote installation
This process is not plug-in-specific. For more information, see the topic on deploying clients and plug-in packages in the Dell NetVault Backup Administrator’s Guide.
|
1 |
In the Navigation pane, click Guided Configuration. |
|
2 |
|
3 |
|
4 |
In the Package Store list, select the applicable repository. |
|
5 |
Click Add NetVault plug-in package. |
|
6 |
In the Select packages for deployment dialog, select the file entitled “sql-x-x-x-x.npk,” where xxxx represents the version number, and click Ok. |
|
7 |
Click Next. |
|
8 |
On the Machines to Have NetVault Software Installed page, select the applicable machines. |
|
9 |
If you are installing an upgrade, select Allow existing NetVault client installations to be upgraded. |
|
10 |
Click Install Software/Add Clients. |
|
11 |
After the plug-in is successfully installed, click Next to complete the process. |
Installing or upgrading the plug-in in a high-availability environment
Installation of the plug-in in a high-availability environment is completed through the creation of a Virtual Client on the NetVault Backup Server. A Virtual Client is a group of nodes within the cluster. NetVault Backup Server views this group as a single client that is created to back up a single clustered resource, for example, a SQL Server Virtual Server. During the Virtual Client creation process, the plug-in is transferred from the NetVault Backup Server to selected nodes within a cluster and installed there.