Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 11.2 - 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

Entering logon credentials for all instances on a client

If all instances use the same logon credentials, use this procedure to specify the default credentials. The plug-in also lets you omit the name and password and use the Log on as account information defined for the NetVault Process Manager service.

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
Double-click Plug‑in for SQL Server.
4
Select the All Instances 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.
7
To save the settings, click OK.

Configuring an instance at all instances level on a client

The InstanceConfig option in the Actions list helps to use the plug-in with previous versions of NetVault Backup Server. This option is available if the All Instances node is selected. This option is similar to the Configure option; however, this option lets you specify the exact name of an instance and does not require specific credentials.

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
Double-click Plug‑in for SQL Server.
4
Select the All Instances node.
5
From the Actions list, select InstanceConfig.
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: Type the name of the instance to configure. If it is a named instance, type the full instance name.
7
To save the settings, click OK.

Entering default logon credentials for a specific SQL Server Instance

If a specific instance uses different logon credentials, such as those described in Authentication Modes, from the credentials used by default, use this procedure to enter the different credentials. Information that you enter during this process overrides what you specified in Entering logon credentials for all instances on a client.

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
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 or AlwaysOn Availability Group 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: Usually, the plug-in automatically identifies and completes this field, and you cannot change it. If the plug-in is unable to determine the instance name, such as when you are configuring an AlwaysOn Availability Group, 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.
7
If you are configuring Virtual Clients for an AlwaysOn Availability Group and 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 6.
c
Fail back to the primary node.
8
To save the settings, click OK.
9
If you need to enter different authentication information for additional SQL Server Instances, repeat Step 4 through Step 8 until all instances are configured.
With the account properly configured, you can click the All Instances node to display the specified instances.
10
If your environment uses multiple Virtual Servers in the same SQL Server 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, and then select Configure from the Actions list.
e
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.
f
Repeat steps Step b through Step e for all remaining Virtual Clients, ensuring that the proper SQL Server Virtual Server is selected for each Virtual Client.

Enabling communication between nodes in an AlwaysOn Availability Group

The plug-in uses the NetVault Backup Virtual Client to manage the NetVault Backup processes on all replicas included in one group. If you are using the plug-in with NetVault Backup 10.x or earlier, use the following process to enable communication between the plug-in and the replicas. This process ensures that you can back up and restore the databases that reside on the secondary replicas in a group.

1
From a command prompt on the first replica included in the group, type:
cd <NetVaultBackupInstallDirectory>\util
The default installation directory is C:\Program Files (x86)\Quest\NetVault Backup\util or the corresponding directory under C:\Program Files.
2
For each NetVault Backup client that was added to the Virtual Client, type:
nvclientaccess <clientName>
where <clientName> is the name of the NetVault Backup Client that was added to the Virtual Client. You can run this command for each client from any machine.
For example, if you have two nodes, run nvclientaccess <clientName> on Node1 with <clientName> as Node2, and then run nvclientaccess <clientName> on Node2 with <clientname> as Node1.
3
When the prompt appears, type the master password for the specified client.
This password is the same one that you specified when you added the client to the NetVault Backup Server. This password lets remote NetVault Backup machines access the client.
4
Repeat these steps for every replica included in the group.
You can run these two commands for each client from any machine.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating