Introducing Quest® NetVault® Backup Plug-in for SQL Server®
Quest NetVault Backup Plug-in for SQL Server: at a glance
Key benefits
Feature summary
Target audience
Recommended additional reading
Planning your SQL Server deployment
Deployment overview
Standalone deployment
High-availability deployments
NetVault Backup Policy Management
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 the NetVault Backup Virtual Client
Configuring plug-in options
Entering logon credentials for all instances on a client
Configuring an instance at all instances level 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
Configuring domain administrator account for service exploration
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
Additional prerequisites for a high-availability deployment
Before installing Plug‑in for SQL Server, check that the requirements are met:
|
• |
Microsoft SQL Server Failover Clustering or AlwaysOn environment in place: You must have a properly configured environment. |
|
• |
Failover Clustering is only supported with SQL Server® Standard and Enterprise Editions. For more information on installing Failover Clustering, see the Failover Clustering section of SQL Server 20xx Books Online. |
|
• |
AlwaysOn requires SQL Server 2012 and later and is supported on Windows 2008® R2 and later. For more information, see the applicable Microsoft documentation: http://msdn.microsoft.com/en-us/library/hh510230(v=sql.120).aspx |
|
• |
Separate NetVault Backup Server machine: The machine that serves as the NetVault Backup Server must be configured and it must exist outside the SQL Server cluster. The machine must have network connectivity to the nodes (hosts) within the cluster. |
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-x.npk,” where xxxxx represents the version number and platform, 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 Quest 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-x.npk,” where xxxxx represents the version number and platform, 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. |