NetVault Plug-in for SQL Server 10.0.6

NetVault Plug-in for SQL Server 10.0.6 - User Guide

Installing the plug-in

The installation process depends on whether you are deploying the plug-in in a standalone or high-availability environment:

•

Installing the plug-in in a standalone environment

•

Installing the plug-in in a high-availability environment

Installing the plug-in in a standalone environment

To install the plug-in:

Access the NetVault Configuration Wizard or Manage Clients page.


	NOTE: If the selected clients are all the same type, you can use the configuration wizard to install the plug-in on multiple clients at the same time. When you select multiple clients, verify that the plug-in binary file is compatible with the OS and platforms of the target clients. From the Manage Clients page, you can only select one client for plug-in installation.

•

To access the NetVault Configuration Wizard page:

In the Navigation pane, click Guided Configuration.

On the NetVault Configuration Wizard page, click Install Plugins.

On the next page, select the applicable clients.

•

To access the Manage Clients page:

In the Navigation pane, click Manage Clients.

On the Manage Clients page, select the machine that contains the SQL Server®, and click Manage.

On the View Client page, click the Install Plugin button (

Click Choose Plug-in File, navigate to the location of the “.npk” installation file for the plug-in (on the installation CD or the directory to which the file was downloaded from the website).

Based on the OS in use, the path for this software may vary on the installation CD.

Select the file entitled “sql-x-x-x-x.npk” (where xxxx represents the version number), and click Open.

To begin installation, click Install Plugin.

After the plug-in is successfully installed, a message is displayed.

Installing 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.

Creating a Virtual Client

As noted earlier, the Virtual Client creation process is not plug-in-specific, and you can find complete details in the Dell NetVault Backup Administrator’s Guide. However, consider the following points during the Virtual Client creation process:

•

Assign a name to the Virtual Client: Dell strongly recommends that you use the Virtual Server network name (that is, the Fully Qualified Domain Name [FQDN]) assigned to the SQL Server® as the NetVault Backup Virtual Client name. When you browse a Virtual Client, NetVault Backup locates the node currently in control of the clustered application, and reveals the SQL Server Instance (for example, on the NetVault Backup Selections page). With a Virtual Client name set up as the SQL Server Virtual Server network name, you can recognize the SQL Server Instance for which the Virtual Client was created.

•

Only include relevant cluster nodes in the Virtual Client: Include only the hosts that are relevant to the SQL Server Virtual Server that is to be backed up and restored.

After the creation of the Virtual Client, the plug-in is transferred to all designated cluster nodes and installed locally. You use the installed plug-in by using the Virtual Client to back up and restore shared data (you can only perform backups and restores of data shared within the cluster).

Using multiple SQL Server® Virtual Servers in the same cluster

SQL Server supports the ability to create multiple Virtual Servers in a cluster. However, each Virtual Server can have only one instance of SQL Server running. The following provisions, in addition to the provisions outlined earlier, must be taken into account when using Plug‑in for SQL Server in this configuration.

Create a NetVault Backup Virtual Client for each SQL Server® Virtual Server. Each Virtual Server has its own network name and IP address, and it is displayed as a separate Virtual Client in NetVault Backup.

•

Create an individual NetVault Backup Virtual Client for each SQL Server Virtual Server: For each SQL Server Virtual Server in the cluster, create a separate Virtual Client. During the creation process, ensure that the following are included:

•

IP Address of the SQL Server Virtual Server: In the Virtual Client Address field of the Virtual Client page, enter the IP Address assigned to the appropriate SQL Server Virtual Server. For example, if you are creating the first of the two SQL Server Virtual Servers in a failover cluster, enter the IP address assigned to the first Virtual Server.

•

Give a name to the Virtual Client that corresponds to the network name of the SQL Server Virtual Server: Enter the network name associated with the SQL Server Virtual Server in the Virtual Client Name field.

Figure 3. Creation of Virtual Client for first SQL Server Virtual Server in clustered environment that contains Virtual Servers

•

Copy the “nvsqlserver.cfg” file before creating the next NetVault Backup Virtual Client: Because creating a new Virtual Client overwrites the configuration file, which includes the Logon Detail information, Dell recommends that you perform the following steps:

Store a copy of the first “nvsqlserver.cfg” file in a safe location.

You can find this file in: \\<NetVaultBackupInstallDirectory>\config

Create the next Virtual Client, store a copy of its “nvsqlserver.cfg” file in a safe location, and repeat this step for every new Virtual Client that you need to create.

Ensure that the correct network name for the SQL Server Virtual Server and IP address is provided for each.

When you have finished creating Virtual Clients, copy the information from the [Security-<instanceName>] and [ServerList:List] sections in each “nvsqlserver.cfg” file to the same sections in the “nvsqlserver.cfg” file on the primary node.

If you have browsed the Virtual Client, close and reopen the NetVault Backup Selections page.

Licensing the plug-in

The plug-in supports backup and restore of shared data only. For a SQL Server® Failover Cluster or AlwaysOn environment, only a single license is needed — a clustered application license for the Virtual Client.

For information on the licensing process, including how to obtain the proper license keys, see the Dell NetVault Backup Installation Guide.