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
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
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
Installing and removing the plug-in
Installation prerequisites
The requirements vary depending on your configuration:
Prerequisites for a standalone deployment
Before installing Plug‑in for SQL Server, check that the following software is installed and configured on the machine that is to host SQL Server®:
|
• |
NetVault Backup Server and Client software: At a minimum, the Client version of NetVault Backup software must be installed on the machine configured as the SQL Server. |
|
• |
SQL Server software: The machine must be running a supported version of SQL Server. For a list of supported versions, see the Quest NetVault Backup Compatibility Guide, which is available at https://support.quest.com/technical-documents. |
|
IMPORTANT: Service Pack 2 is a requirement for SQL Server 2005 to run on Windows Server® 2008, both 32-bit and 64-bit. For more information, see http://www.microsoft.com/sqlserver/2005/en/us/system-requirements.aspx#ws. |
|
• |
SQL Server VSS Writer Services: If you want to implement a VSS backup strategy for SQL Server databases, the SQL Server VSS Writer service must be running. The SQL Server VSS Writer is automatically installed. However, the service is not set to start automatically. To enable VSS backups, use the Windows Services utility. Quest recommends that you set the Startup Type for this service to Automatic. |
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. |