지금 지원 담당자와 채팅
지원 담당자와 채팅

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

1
In the Navigation pane, click Create Backup Job, and click Create New next to the Selections list.
3
Double-click Plug‑in for SQL Server.
4
Select the All Instances node.
5
From the Actions list, select Configure.
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:
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.
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.

Entering default logon credentials for a specific SQL Server Instance

1
In the Navigation pane, click Create Backup Job, and click Create New next to the Selections list.
3
Double-click Plug‑in for SQL Server, and double-click the All Instances node to display the list of SQL Server® Instances.
5
From the Actions list, select Configure.
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:
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.
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.
b
With the account properly configured, you can click the All Instances node to display the specified instances.
a
In the Navigation pane, click Create Backup Job, and click Create New next to the Selections list.
c
Double-click Plug‑in for SQL Server, and double-click the All Instances node.
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

cd <NetVaultBackupInstallDirectory>\util
The default installation directory is C:\Program Files (x86)\Dell\NetVault Backup\util or the corresponding directory under C:\Program Files.
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.

Changing the TCP/IP port for SQL Server®

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택