Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 10.0.6 - User Guide

Introducing Dell™ 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 Restoring data Troubleshooting

Removing a SQL Server® Instance

To remove an instance:
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.
3
Double-click Plug‑in for SQL Server, double-click the All Instances node, and click the applicable instance to select it.
4
From the Actions list, select Remove.
5
When the confirmation message appears, click Yes.

Configuring the plug-in

•
Configuring authentication details
•
Configuring the NetVault Backup Virtual Client
•
Enabling communication between nodes in an AlwaysOn Availability Group
•
Specifying a default configuration (optional)
•
Changing the TCP/IP port for SQL Server®
•
Setting up SQL Server® Authentication for SQL Server 2012 or later

Configuring authentication details

Before initiating a backup, you must configure the plug-in’s authentication details, which include authentication mode, user name, and password.
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, provides support for 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 Logon 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.
To configure authentication:
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.
3
Double-click Plug‑in for SQL Server, and double-click the All Instances node to display the list of SQL Server® Instances.
Because you can use a single SQL Server installation to create multiple instances and configure authentication differently for each instance, NetVault Backup supports the use of different authentication information for different instances. If you only create one instance, that node is labeled “(local).”
4
Select the node for the first SQL Server Instance that you want to configure (if you only have one instance, select the “(local)” node).
5
From the Actions list, select Configure.
6
Complete the applicable fields:
•
Logon security mode: Based on the Authentication Mode set for the SQL Server Instance, you can specify either a Windows® Administrator or a SQL Server Administrator account. To specify a Windows Administrator account, select Windows. For a SQL Server Administrator account, select SQL Server.
 
* 
IMPORTANT: You can only select SQL Server if the SQL Server Authentication Mode is set to Mixed Mode/SQL Authentication.
•
Login Details: Depending on the option selected in the Logon security mode section, provide the appropriate account information in this section:
•
For Windows® authentication, provide the following information:
•
Administrator User Name: Specify either a Local or Domain Windows Administrator user name.
•
Password: Enter the password associated with the user specified in the preceding field.
•
Windows Domain: If a Domain Administrator is specified in the Administrator User Name field, enter the name of the domain. You can leave this field blank if a Local Administrator user name is specified.
•
For SQL Server authentication, provide the following information:
•
Administrator User Name: Specify a SQL Server user with the sysadmin role.
•
Password: Enter the password associated with the user specified in the preceding field.
•
Instance Name: Specify the exact name of the SQL Server Instance running. When NetVault Backup locates the instance, the instance is displayed on the NetVault Backup Selections page for browsing and inclusion in a backup job.
 
* 
IMPORTANT: The default credentials are those credentials configured for the All Instances node with no instance name specified.

If you enter the logon credentials and omit the Instance Name, NetVault Backup uses the default credentials when it accesses instances for which no information was provided. You might find this method useful in multiple-instance environments.
7
To save the settings, click OK.
8
If you need to enter different authentication information for additional SQL Server Instances, repeat Step 4 through Step 7 until all instances are configured.
With the account properly configured, you can click the All Instances node to display the specified instances.

Configuring the NetVault Backup Virtual Client

After installing (or reinstalling) a NetVault Backup Virtual Client and before performing a backup or restore, you must configure the NetVault Backup Virtual Client from the NetVault Backup Server. The process for configuring the Virtual Client depends on whether you are using a SQL Server Failover Cluster or an AlwaysOn Availability Group.
To configure the Virtual Client for a SQL Server Failover 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, and double-click the All Instances node.
4
From the Actions list, select Configure.
5
Complete the applicable fields.
For more information, see Configuring authentication details.
 
* 
IMPORTANT: Add each cluster instance in the Instances field of the Configure dialog box. To add an instance, specify the SQL Server cluster name as VIRTUAL SERVER NAME\INSTANCE NAME.
6
If you anticipate having to create additional 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 5.
c
Fail back to the primary node.
7
To save the settings, click OK.
8
If your environment uses multiple Virtual Servers in the same failover cluster, complete the following steps for each Virtual Client you created:
a
In the Navigation Pane, click Create Backup Job, and click Create New next to the Selections list.
b
In the selection tree, open the newly created Virtual Client that was set up for the first SQL Server® Virtual Server.
c
Double-click Plug‑in for SQL Server, and double-click the All Instances node.
All the SQL Server Virtual Servers within the failover cluster are revealed.
d
Select the first SQL Server Virtual Server in the tree.
e
From the Actions list, select Configure.
f
Complete the applicable fields.
With the configuration set for the first SQL Server Virtual Server in its corresponding Virtual Client, repeat the process for all remaining SQL Server Virtual Servers.
g
Repeat steps Step b through Step f for all remaining Virtual Clients, ensuring that the proper SQL Server Virtual Server is selected for each Virtual Client.
To configure the Virtual Client for an AlwaysOn Availability 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 remaining fields.
For more information, see Configuring authentication details.
 
* 
IMPORTANT: In addition to this initial configuration, you can also enter SQL Server Instance configuration details in the NetVault Backup 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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating