When you perform SQL Server backups on an industrial scale, it is easy to get confused with the created backup files, as the backup itself consists of binary data, making it impossible to understand by simply opening it in a text editor. In this article, we will look at what SQL Server offers to avoid … Read more
This simple guide will help you create backups of SQL Server on Linux.
The only noticeable difference is in the graphical tools.
SSMS is the main tool for SQL Server and is only available on Windows. Connecting from Windows to SQL Server on Linux is not always possible due to port security (1433). You will have to use the command line utility sqlcmd and T-SQL commands.
Documentation for the SqlBak product is currently under development. We apologize for any inconvenience.
While the documentation is being finalized, you can reach out to us through our support service, and we will strive to respond to your inquiry within a few hours.
Below is a list of articles from our blog where you can find useful materials on using SqlBak:
Log shipping in Microsoft SQL Server is an automated solution for master-slave replication based on the transfer of transaction logs from primary to secondary servers. This process ensures continuous database cloning while minimizing the load on the primary server.
SqlBak enables the execution of SQL scripts and Windows batch scripts within backup or maintenance jobs. By default, script execution is disabled for security reasons. When attempting to add a script to a job, an error message may appear:
Execution of <script type> is prohibited. To allow script execution, please enable the corresponding option in the SqlBak App security settings.
Currently, SqlBak has access to all files and folders on Google Drive. Now, SqlBak will request access only to the files and folders on Google Drive created by SqlBak.
To perform a SQL Server backup is very simple — it can be done in 5 clicks via SSMS. But the topic of backups in SQL Server is deep.
Take a seat, young Padawan, for this article will be your first step toward becoming a Jedi Backup Master.
SSH (Secure Shell) is a method of secure data transmission over a network.
Administrators often encounter it when connecting to a Linux server by entering the command ssh userName@hostAddress, which allows them to execute commands on the remote server.
However, it is primarily a protocol, and on top of it, you can not only transmit data but also create SSH tunnels, allowing applications to transfer data over SSH.
Targeted at DBAs, this article offers an overview of CLI utilities for MySQL backup. The commands described can be implemented in Linux Shell (.sh) scripts, as well as in Windows cmd (.bat) and PowerShell (.ps1) scripts. In addition to creating backups, dumps and exporting data, we’ll also delve into MySQL restore commands.
A MySQL dump is a file that contains SQL commands, which, when executed, would lead to the recreation of the MySQL database at the moment of the dump’s export. Essentially, a MySQL dump database is a logical MySQL backup database.
mysqldumpis a utility that creates a MySQL dump. It is part of MySQL and MariaDB and gets installed alongside the MySQL client.
