If you get the following error message during SqlBak set up on Linux or during a backup job:
MS SQL Server DBMS – /bin/sh: 1: /opt/mssql-tools/bin/sqlcmd
it means that SqlBak app could not find the path to the msql executables. By default, SqlBak searches for mssql files in the /opt/mssql-tools/bin/sqlcmd directory.
How to resolve the issue
Please follow these step to resolve the issue:
Make sure that sqlcmd is installed
To do this, please execute:
in response, you should get something similar to:
Microsoft (R) SQL Server Command Line Tool
Version 17.4.0001.1 Linux
Copyright (c) 2012 Microsoft. All rights reserved.
If you get an error message that the command was not found, then install sqlcmd through the standard package manager. For Ubuntu, this can be done like so:
sudo apt-get install sqlcmd
Find the path where sqlcmd is installed
Specify sqlcmd path for SqlBak
sudo sqlbak -us -sq <your/path/to/sqlcmd>