Installing the sqlpackage client utility
You need to install this utility to protect the following databases:
Azure SQL
Azure SQL Managed Instance
AWS RDS SQL server
GCP SQL server
The sqlpackage client utility recommended version is 19.2 (Build: 162.0.52).
To install, run the following commands in the terminal:
- cd ~
- mkdir sqlpackage
- unzip ~/Downloads/sqlpackage-linux-<version string>.zip -d ~/sqlpackage
- echo "export PATH=\"\$PATH:$HOME/sqlpackage\"">> ~/.bashrc
- chmod a+x ~/sqlpackage/sqlpackage
- source ~/.bashrc
Note:
Ensure that the
sqlpackageis added as a default path variable. If you still get the: Cannot findsqlpackageerror, restart the NetBackup services on the media server. - sqlpackage
- rpm -ivh unixODBC-2.3.7-1.rh.x86_64.rpm
- rpm -ivh msodbcsql17-17.10.2.1-1.x86_64.rpm
If you still get the error: sqlpackage client utility does not exist on the given host, create a soft link for the sqlpackage to the path /usr/bin/sqlpackage.
For example:
If the sqlpackage is located at /root/sqlpackage/sqlpackage, create a soft link and then run the backup as:
ln -s /root/sqlpackage/sqlpackage/usr/bin/sqlpackage
RHEL 9 users perform the following additional steps:
- Download the Microsoft.NETCore.App.Runtime.linux-x64 from the link:
https://www.nuget.org/api/v2/package/Microsoft.NETCore.App.Runtime.linux-x64/6.0.10
Locate the file:
microsoft.netcore.app.runtime.linux-x64.6.0.10.nupkg. - Extract the file using a decompression tool like, 7zip.
- Navigate to:
microsoft.netcore.app.runtime.linux-x64.6.0.10.nupkg\runtimes\linux-x64\lib\net6.0\
- Copy the file
System.Security.Cryptography.X509Certificates.dllfrom there to the~/sqlpackagefolder created in step 2 of installing the sqlpackage client utility task.
If you are attaching the 10.1 media server as an external media server with 10.1.1 NetBackup setup, perform the following steps on the 10.1 media server.
For a BYO NetBackup setup:
Run the command:
mkdir -p <backup and restore ushare export path>
Check the
Defaultversvalue of NFS in the/etc/nfsmount.conffile.If the
Defaultversvalue isnfs3, then mount the backup and restore ushare path with the optionnolock. For example: mount <ushare mount path> <ushare export path> -o nolockIf the
Defaultversisnfs4, mount the backup and restore ushare path without thenolockoption.
For NetBackup deployed in AKS and EKS environments:
Run the command:
mkdir -p <backup and restore ushare export path>
Check the
Defaultversvalue of NFS from the/etc/nfsmount.conffile.If the
Defaultversvalue isnfs3, then mount the backup and restore ushare path with the optionnolockFor example: mount <ushare mount path> <ushare export path> -o nolockIf the
Defaultversvalue isnfs4, then mount the v4 version of backup and restore ushare path without thenolockoption.