SQLBackupAndFTP is a versatile tool specifically developed for database backup and restoration. It enables users to create backups and restore them within the same DBMS. It also offers the capability to back up Azure SQL databases and restore them in SQL Server, and vice versa. To help you migrate data from Azure SQL to SQL Server, we have prepared a comprehensive step-by-step guide on configuring backup and restore jobs. Continue reading How to Import Azure SQL Databases to SQL Server
All posts by Alex
How to Import SQL Server Databases to Azure SQL
SQLBackupAndFTP is a utility designed for backing up and restoring databases. It not only allows you to create backups and restore them within a single DBMS, but also provides the functionality to backup SQL Server databases (local or remote) and restore them in Azure SQL, and vice versa. Below is a step-by-step guide on how to configure backup and restore jobs to migrate data from SQL Server to Azure SQL.
Continue reading How to Import SQL Server Databases to Azure SQL
Simplifying Data Protection with SQLBackupAndFTP and SFTP To Go
We all know creating backups is half the battle. Finding the right place for storage is the other half. Today, let’s see how SQLBackupAndFTP and SFTP To Go can collaborate to solve both tasks.
Continue reading Simplifying Data Protection with SQLBackupAndFTP and SFTP To Go
How to Enable Binary Logging for MySQL Server on Windows
To perform MySQL Server incremental backups, binary logs should be enabled and correctly set. Otherwise, you will see one of the following error messages:
Failed to backup “mysql” database with “Full” backup type: [DBMS-MYSQL:11015#1] Unexpected binary log format. Current value: “MIXED”, expected value: “ROW”. Log in to the DBMS using the MySQL official client or other tools and run the statement to update the binary log format: set global binlog_format = ‘ROW’;
Failed to backup “mysql” database with “Incremental” backup type: [DBMS-MYSQL:11014#1] Binary log is not enabled. Current value of “log_bin” variable: “OFF”. Expected value: “ON”.
Continue reading How to Enable Binary Logging for MySQL Server on Windows
How to Schedule a Script via Windows Task Scheduler
A script can be run via the built-in Windows Task Scheduler tool. It can be found in the “Administrative Tools” section, or by clicking Win+R and typing taskschd.msc
. Open the scheduler and in the “Actions” section select Create Task… Continue reading How to Schedule a Script via Windows Task Scheduler
How to connect to MySQL Server using SSH key pairs
To backup MySQL Server via SQLBackupAndFTP, you have to establish a connection via TCP/IP. In other words, SQLBackupAndFTP connects to a database via port 3306.
Continue reading How to connect to MySQL Server using SSH key pairs
Command Line Arguments to Manage an Installation
Assume you need to clone your server and you have an image, for example, an AMI (Amazon Machine Image) in AWS with installed SQLBackupAndFTP Free edition. Once you deploy this image on several servers and apply your license key to activate SQLBackupAndFTP, that license key will be applied to all your servers. When you decide to remove your license from one of the servers, the license will be removed from all of them. Also, you can face the issue that the license will not work if you activate a license for one server on all your cloned servers. Continue reading Command Line Arguments to Manage an Installation
How to Set Up Log Shipping
If there is a need to synchronize databases on your primary server with databases located on your secondary server, then log shipping is exactly what you need. In the following article, you can find a detailed explanation about that option and the different ways to do it using SQLBackupAndFTP. Continue reading How to Set Up Log Shipping
How to Automate MySQL Database Backups in Windows
Preservation of data is an essential part of any business. Losing a database, such as a customer list, could effectively be the end of a company. The primary way to protect your data is to regularly back it up.
In this article, we will explain how to automate regular backups for MySQL on Windows. If you use Linux, check out this article: How to Automate MySQL Database Backups in Linux.
Continue reading How to Automate MySQL Database Backups in Windows
How to clone SQL SERVER database to a Test Environment
It doesn’t matter if a company is large or small, almost every database administrator needs to maintain a copy of the production databases in a test environment for testing and development needs.
All you need to do for this is to copy the databases from the production server to a test server, and this can be done in different ways. Let’s take a look at them. Continue reading How to clone SQL SERVER database to a Test Environment