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

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.

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 option DomainAdmin is added in the Actions list 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 Actions list, select DomainAdmin.
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.
6
To save the settings, click OK.

 

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
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating