Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 14.0 - User Guide

Introducing NetVault 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 Understanding snapshot-based backups 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 on Windows Removing a SQL Server Instance
Restoring data Using the CLI with the plug-in Troubleshooting

Removing the plug-in from a standalone deployment

For details on removing the Plug‑in for SQL Server in high-availability deployment, see the applicable topic on working with client clusters in the Quest NetVault Administrator’s Guide.

 
* 
CAUTION: Removing the plug-in does not remove the configuration settings that you created. If you reinstall the plug-in or install a newer version, the plug-in typically uses the same configuration settings from the previous installation unless otherwise indicated in the release notes.
1
In the Navigation pane, click Manage Clients.
2
On the Manage Clients page, select the applicable client, and click Manage.
3
In the Installed Software table on the View Client page, select Plug‑in for SQL Server, and click the Remove Plugin button ().
4
In the Confirm dialog box, click Remove.

 

 

 

Configuring the plug-in

•
Configuring authentication details
•
Configuring the NetVault Virtual Client on Windows
•
Configuring plug-in options
•
Entering logon credentials for all instances on a client
•
Configuring an instance at the All Instances level on a client
•
Entering default logon credentials for a specific SQL Server Instance
•
Changing the TCP/IP port for SQL Server
•
Setting up SQL Server Authentication for SQL Server 2012 or later (Windows only)
•
Configuring domain administrator account for service exploration

Configuring authentication details

Before initiating a backup, configure the plug-in’s authentication details, which include authentication mode, user name, and password. Use the Configure dialog to specify this information.

How the information that you enter in the Configure dialog applies depends on whether you are configuring a client for a standalone deployment or a NetVault Virtual Client for a SQL Server Failover Cluster or an AlwaysOn Availability Group. When you enter settings for a standalone client, the settings apply to all backups generated from that client when it is selected in the selection tree. If you use Virtual Clients to support a SQL Server Failover Cluster or an AlwaysOn Availability Group, the authentication information that you enter for a specific instance in the cluster or group is used for all nodes within the same cluster or group. All information that you enter on the Configure dialog for a cluster or group is maintained on the NetVault Server, unlike a standalone deployment for which the information is maintained on the server on which the plug-in is installed.

Authentication modes

SQL Server provides two authentication modes: Windows Authentication and SQL Server Authentication.

•
Windows Authentication: With Windows Authentication, you connect through a Microsoft Windows user account. SQL Server validates the account name and password using information in the Windows OS. This method is the default, and is much more secure than Mixed Mode, which allows a combination of Windows authentication and SQL Server Authentication.
Windows Authentication uses Kerberos security protocol, provides password policy enforcement in terms of complexity validation for strong passwords, supports account lockout, and supports password expiration. Microsoft strongly recommends implementing a Windows Authentication mode for SQL Server.
•
SQL Server Authentication: With SQL Server Authentication on SQL Server 2008 or earlier, you must provide the user name and password for a SQL Server user with the sysadmin role. With SQL Server Authentication on SQL Server 2012 or later the sysadmin role is not supported. However, you can assign the sysadmin role to a domain user account, such as Administrator, or you can set the SQL Server service to run using the Log on as option set to a domain user that has the privileges. For a system that is not part of a domain, you can assign the role to a local user or you can set the SQL Server service to run under the local user that has the privileges. For more information, see Setting up SQL Server Authentication for SQL Server 2012 or later (Windows only).

Configuring the NetVault Virtual Client on Windows

After you install, or reinstall, a NetVault Virtual Client and before you perform a backup or restore, ensure that the NetVault Virtual Client is configured. The process for configuring the Virtual Client depends on whether you are using a SQL Server Failover Cluster or an AlwaysOn Availability Group.

Configuring the Virtual Client for a SQL Server Failover cluster deployment

In a SQL Server Failover deployment, the SQL Server Failover Virtual Instance is automatically detected if the SQL Server Browser Service is running in all the nodes of the Failover Cluster. Otherwise, to add SQL Server Failover Virtual Instance using the Add Instance Action, follow these steps:

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 newly created Virtual Client.
3
Double-click Plug‑in for SQL Server, and double-click the All Instances node.
4
From the context menu, select Configure.
5
Complete the applicable fields. For more information, see Configuring authentication details.
 
* 
IMPORTANT: Add the cluster instance name in the Instances field of the Configure dialog box. To add an instance, if necessary, you might specify the SQL Server cluster name as VIRTUAL SERVER NAME\INSTANCE NAME
6
To save the settings, click OK.
7
Optionally, if you anticipate having to create more backup jobs or modify existing backup jobs on the secondary nodes, perform the following steps:
a
Fail over the primary node to the secondary node.
b
Repeat Step 1 through Step 6.
c
Fail back to the primary node.

If your environment uses multiple Virtual Servers in the same failover cluster, create a NetVault Virtual Client for each Virtual SQL Server, and complete the previous steps for each Virtual Client you created.

Configuring the Virtual Client for an AlwaysOn Availability Group deployment
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 newly created Virtual Client.
3
Double-click Plug‑in for SQL Server.
4
In the Configure dialog box, enter the credentials of the domain user that is used as the default user for accessing SQL Server Instances in the group.
5
Complete the applicable fields. For more information, see Configuring authentication details.
 
* 
IMPORTANT: In addition to the initial configuration, you can also enter SQL Server Instance configuration details in the NetVault Virtual Client. You can enter this information at the All Instances level or at the individual instance level. This process works the same way as described in Configuring authentication details.
6
To save the settings, click OK.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating