This article will address the issue of backup encryption, why it is important, and the various approaches available. Why encrypt backups? Application-level encryption and “always encrypted” Simple backup encryption (7zip) SQL Server backup encryption Creating a certificate IMPORTANT: certificate backup Creating a backup with built-in encryption in SQL Server Restoring an encrypted SQL Server backup … Read more
In this article, various methods of monitoring backups and restores of SQL Server databases will be discussed, including tracking current progress and history. Tracking the status of your initiated backup If you initiate a backup yourself, you can instruct SQL Server to log the progress status by adding the WITH STATS parameter to the BACKUP … Read more
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:
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.
因为有几种方法可以在Windows上备份MySQL数据库，本文将回顾所有不同的选项，以便您选择适合您的方法。本文仅限于Microsoft Windows服务器上的MySQL数据库备份。如果您使用的是基于Linux的操作系统，请参阅如何在Linux中自动化MySQL数据库备份。
本博客文章所述解决方案适用于任何 Linux 发行版：Ubuntu、Red Hat、Open SUSE、CentOS、Debian、Oracle Linux 等。然而，包安装命令可能会有所不同。
自动备份 MySQL 服务器数据库对于防止数据丢失至关重要。要正确自动化备份，您需要按照以下步骤执行：
