Chat now with support
Chat with Support

NetVault Plug-in for SQL Server 12.2 - 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 on Windows
Restoring data Using the CLI with the plug-in Troubleshooting

Additional prerequisites for a high-availability deployment

Before installing Plug‑in for SQL Server, check that the requirements are met:

•
Microsoft SQL Server Failover Clustering or AlwaysOn environment in place: You must have a properly configured environment.
•
Failover Clustering is only supported with SQL Server Standard and Enterprise Editions. For more information on installing Failover Clustering, see the Failover Clustering section of SQL Server 20xx Books Online.
•
AlwaysOn requires SQL Server 2012 or later and is supported on Windows 2008 R2 and later. For more information, see the applicable Microsoft documentation.
•
For SQL Server 2012, see: http://msdn.microsoft.com/en-us/library/hh510230(v=sql.110).aspx
•
For SQL Server 2014, see: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-2014
•
For SQL Server 2016, see: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-2016
•
For SQL Server 2017, see: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-2017
•
For SQL Server 2019, see: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-ver15
•
Separate NetVault Backup Server machine: The machine that serves as the NetVault Backup Server must be configured and it must exist outside the SQL Server cluster. The machine must have network connectivity to the nodes (hosts) within the cluster.

Prerequisites for Linux

Before installing the plug-in in a Linux environment, verify that the following prerequisites are met:

•
The Microsoft ODBC Driver for SQL Server is installed.
The ODBC Driver is required for querying the SQL Server. Installation of the ODBC Driver varies depending on the Linux distribution that you are using. To ensure installation of the appropriate driver for your Linux distribution, see https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server.
If you are using SQL Server 2017 on Linux, Quest strongly recommends that you use the Microsoft ODBC Driver 17 for SQL Server. Make sure that you enter the name of the ODBC Driver in the Plug‑in for SQL Server Configure dialog box. For more information see Configuring the plug-in.
•
A link to the VDI library exists in the default directory for 64-bit libraries.
When you install SQL Server on Linux, the shared VDI Client library, “libsqlvdi.so,” is installed in the /opt/mssql/lib directory by default.
When you install the Plug‑in for SQL Server, a symbolic link to “libsqlvdi.so” is created in the default 64-bit library path. For Ubuntu, the default path is /usr/lib/x86_64-linux-gnu. For Red Hat Enterprise Linux (RHEL) and SUSE Linux Enterprise Server (SLES), the default path is /usr/lib64. After you install the plug-in on Linux, verify that a symbolic link exists from the default 64-bit library path to “libsqlvdi.so.” If the library itself or a symbolic link is not present in the default path, create one.
Example of creating a symbolic link in RHEL or SUSE:
ln -s /opt/mssql/lib/libsqlvdi.so  /usr/lib64/libsqlvdi.so
Example of creating a symbolic link in Ubuntu:
ln -s /opt/mssql/lib/libsqlvdi.so /usr/lib/x86_64-linux-gnu/libsqlvdi.so
•
The root user for the operating system (OS) belongs to the Microsoft SQL Server Group (mssql), and the mssql user belongs to the root group.
When you install SQL Server on Linux, the mssql user and group are created for the OS. Only OS users of the mssql group have access for queries and as a VDI Client. The plug-in requires an OS VDI user to access the SQL Server. The OS VDI user and the mssql user must belong to the mssql group, and the mssql OS user has to belong to the OS VDI group.
 
* 
NOTE: The plug-in requires that you use the root user as the OS VDI user.
Example of adding the root user to the mssql group:
sudo usermod -a -G mssql root
Example of adding the mssql user to the root group:
sudo usermod -a -G root mssql
 
* 
IMPORTANT: Quest strongly recommends that you install the Microsoft Command Line Utilities for SQL Server — the mssql-tools package.

Installing or upgrading the plug-in in a standalone environment

You can install or upgrade the plug-in on individual systems, one at a time. You can also deploy the plug-in to multiple machines by creating a deployment task from the WebUI to push the packages to the specified machines. You can use this method for both new and upgrade installations. After the packages are installed on the machines, the new machines are automatically added to the NetVault Backup Server.

•
Performing a local installation
•
Performing a remote installation

Performing a local installation

1
In the Navigation pane, click Manage Clients.
2
On the Manage Clients page, select the machine that contains the SQL Server, and click Manage.
3
On the View Client page, click the Install Plugin button ().
4
Click Choose Plug-in File, navigate to the location of the “.npk” installation file for the plug-in, for example, on the installation CD or the directory to which the file was downloaded from the website.
Based on the OS in use, the path for this software may vary on the installation CD.
5
Select the file entitled “sql-x-x-x-x-x.npk,” where xxxxx represents the version number and platform, and click Open.
6
To begin installation, click Install Plugin.
After the plug-in is successfully installed, a message is displayed.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating