Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 11.4.5 - User Guide

Introducing Quest® NetVault® Backup Plug-in  for SQL Server® Planning your SQL Server deployment Installing and removing the plug-in Configuring the plug-in Backing up data
Defining a backup strategy Reviewing the compression features Performing Online VDI backups Performing VSS backups in SQL Server® Example of creating a full VDI backup of an AlwaysOn Availability Group
Restoring data Troubleshooting

Configuring domain administrator account for service exploration

For certain activities on Windows, it is necessary to impersonate a member of Administrators group on the client(s). An option Enter Domain Administrator is added in the Actions list to configure a Windows Domain Administrator for clusters, even if the default login configuration is not a Windows user.

1
In the Navigation pane, click Create Backup Job, and click Create New next to the Selections list.
2
In the selection tree, open the applicable client node.
The client node can be a standalone server or Virtual Client.
3
Click Plug‑in for SQL Server.
4
From the Actions list, select Enter Domain Administrator.
5
Enter the login credentials for a domain account which is a member of the Administrators group on all cluster nodes:
•
User Name: Specify a domain Windows Administrator user name.
•
Password: Enter the password associated with the user specified in the preceding field.
•
Domain: Enter the name of the domain.
 
* 
NOTE: The user whose login credentials are entered must be a member of the Administrators group on all nodes of a cluster, if the client is a virtual client.
•
Reset to blank saved User Name, Password, and Domain: Select this option to reset to the blank or empty, the values stored in the plug-in for User Name, Password, and Domain.
6
To save the settings, click OK.

 

Backing up data

•
Defining a backup strategy
•
Reviewing the compression features
•
Performing Online VDI backups
•
Performing VSS backups in SQL Server®
•
Example of creating a full VDI backup of an AlwaysOn Availability Group

Defining a backup strategy

The purpose of creating SQL Server® backups is to recover a database that is damaged from media failure or data corruption. Reliable use of backup for recovery requires a strategy that maximizes data availability and minimizes data loss, while accounting for defined business requirements.

A backup strategy is divided into two pieces: a backup piece and a restore piece.

•
The backup piece defines the type and frequency of backups that are required to meet the goals for availability of the database and for minimizing data loss.
•
The restore piece defines who is responsible for performing restores, and how restores should be performed to recover from the particular type of damage or failure.
 
* 
IMPORTANT: If you use Plug‑in for SQL Server, verify that you are not using a third-party program to complete additional backups of SQL Server. Otherwise, a conflict might occur during the restore or recovery process when the differential backups do not match.

For more information, review the following topics:

•
Reviewing the available backup methods
•
Reviewing SQL Server® recovery models
•
Defining an Online VDI backup strategy and reviewing types
•
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

Reviewing the available backup methods

The plug-in offers the following backup methods:

•
Online Virtual Device Interface (VDI)
•
Volume Shadow Copy Service (VSS)

The plug-in supports implementing an Online VDI or a pure VSS backup strategy, not a combination of the two.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating