Below is the short tutorial on how to enable binary log in Linux. Continue reading How to Enable Binary Log in Linux
Category Archives: Backups
MySQL Backup Strategy
How to Copy SQL Server Database from Windows to Linux
After Microsoft has launched SQL Server for Linux, even if your main tech stack is tied to Windows Server you may need to copy the database to another SQL Server located on a Linux computer.
For example, this can come in handy if you want to provide developers with a database for testing without buying a Windows Server license.
There are a few ways to tackle this task. This article examines the following methods to copy SQL Server database from Windows to Linux:
- Using T-SQL’s BACKUP DATABASE and RESTORE DATABASE commands;
- Generation of T-SQL database script (such as mysqldump);
- Creating BACPAC;
- SqlBak service.
Continue reading How to Copy SQL Server Database from Windows to Linux
MySQL DBMS – /bin/sh: 1: /usr/bin/mysql: not found
If you get one of the following error messages during the setting up of SqlBak on Linux or during the execution of a backup job:
MySQL DBMS – /bin/sh: 1:/usr/bin/mysql: not found
or
MySQL DBMS – /bin/sh: 1:/usr/bin/mysqldump: not found
it means that the SqlBak app could not find the path to the MySQL executables. By default, SqlBak searches for MySQL files in the /usr/bin/mysql directory. Continue reading MySQL DBMS – /bin/sh: 1: /usr/bin/mysql: not found
MS SQL Server DBMS – /bin/sh: 1: /opt/mssql-tools/bin/sqlcmd
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. Continue reading MS SQL Server DBMS – /bin/sh: 1: /opt/mssql-tools/bin/sqlcmd
PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found
If during setting up of SqlBak on Linux or during a backup job one of the following errors occurs:
PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found
or
PostgreSQL DBMS – /bin/sh: 1: /usr/bin/pgdump: not found
it means that SqlBak app could not find the path to postgresql executables. By default, SqlBak looks for postgresql files in the /usr/bin/psql directory. Continue reading PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found
How to fix SqlBak “Service failed” error
That issue may occur if the SqlBak (SQL Server Backup) Windows Service was interrupted by an error. Continue reading How to fix SqlBak “Service failed” error
How to backup large databases. Recommendation.
If you have to backup large SQL Server database with the help of SqlBak, here you will find some recommendations that can speed up the backup process. Continue reading How to backup large databases. Recommendation.
Why SqlBak is better than Microsoft SQL Server Backup to Microsoft Azure Tool?
If you use Azure Storage to keep your SQLServer backups then you are probably already aware of “Microsoft SQL Server Backup to Microsoft Azure Tool” that allows you to send your backups there. In this post, we will show how it works and why SqlBak does the same thing in a more convenient way.
Continue reading Why SqlBak is better than Microsoft SQL Server Backup to Microsoft Azure Tool?
How to create SqlBak backup job in 2 minutes
After you have passed the registration process and connected SqlBak to your server, go to your Dashboard page and create your first backup job. Continue reading How to create SqlBak backup job in 2 minutes
