Tchater maintenant avec le support
Tchattez avec un ingénieur du support

NetVault Plug-in for SQL Server 12.0 - User Guide

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

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 context menu, 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 context menu.
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.

Changing the TCP/IP port for SQL Server

The plug-in does not communicate with a specific port. The plug-in connects with a SQL Server driver, which then communicates with the Database Engine on the configured TCP/IP port. Because the plug-in does not directly use the TCP/IP port itself, you can configure the SQL Server Database Engine to monitor a different port without having to reconfigure the plug-in.

Setting up SQL Server Authentication for SQL Server 2012 or later

Starting with SQL Server 2012, security privileges changed and you cannot use the LocalSystem account. Previously, you could use the LocalSystem account as the default for the sysadmin role. For SQL Server 2012 or later, use a domain account — including Administrator — that has the SQL Server sysadmin role or change the Log on as option for SQL Server Service to use a domain user that has the required privileges. If the SQL Server is not part of a domain, you can use a local user that has the sysadmin role or change the Log on as option for SQL Server Service to use a local user that has the required privileges.

1
Ensure that the selected domain or local user account has the sysadmin role assigned to it.
2
Complete one of the following:
•
In Windows Control Panel > Administrative > Services, locate and select NetVault Process Manager, and click Stop. Right-click NetVault Process Manager, and select Properties. On the Log On tab, ensure that NetVault Backup runs using the account that has the SQL Server sysadmin role. Start the NetVault Process Manager.
•
In the SQL Server Configuration Manager, click SQL Server Services. In the details pane, right-click the name of the applicable SQL Server Instance, and click Properties. In the SQL Server <instanceName> Properties dialog box, click the Log On tab. For Log on as, select the account that has the SQL Server sysadmin role. In Windows Control Panel > Administrative > Services, stop and start the SQL Server Service.
•
Use SQL Server Management Studio to add the domain or local user account that has the sysadmin privileges to the SQL Server. You can use SQL Server Management Studio to add this account, or enter the following in a command prompt:
CREATE LOGIN [<domainName>\<loginName>] FROM WINDOWS;
GO
For more information, see https://technet.microsoft.com/en-us/library/ms189751%28v=sql.110%29.aspx.
SP_ADDSRVROLEMEMBER '<domainName>\<loginName>', 'sysadmin'
GO
For more information, see https://technet.microsoft.com/en-us/library/ms186320(v=sql.110).aspx.
 
* 
NOTE: You can assign the SQL Server sysadmin role to the default Local System user (NT AUTHORITY\SYSTEM), which lets the Plug‑in for SQL Server log into the SQL Server Instances without prompting for credentials. Provisioning the Local System user (NT AUTHORITY\SYSTEM) with the sysadmin role might result in other applications being able to log into the SQL Server Instances without providing credentials. Before assigning the sysadmin role to the Local System user (NT AUTHORITY\SYSTEM), ensure that it is allowed under your compliance requirements.

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 Enter Domain Administrator option is added in the context menu 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 context menu, 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.

 

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation