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
Category Archives: Uncategorized
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 Restore SQL Server Backups
The conventional wisdom says: “Do not care about the backup of the database but about its recovery.” True, backups are created to be recovered, if necessary. In this article, we are going to see how to recover the SQL Server database from a backup copy using SQLBackupAndFTP. Continue reading How to Restore SQL Server Backups
How to backup SQL Server to Yandex Disk
Yandex.Disk is cloud storage from Yandex, the largest technology company in Russia (with 52% market share as a search engine). Yandex.Disk is a good alternative to Google Drive and its features and pricing policy are very similar to Google. Continue reading How to backup SQL Server to Yandex Disk
How to Automatically Backup phpMyAdmin
The fact is that hosting your website on a shared hosting most probably means that the only way to access your MySQL database would be through phpMyAdmin. Moreover, regular backups are still the most efficient way to protect your data, and making this process automatic with phpMyAdmin will make this routine much easier.
The good news is that SQLBackupAndFTP allows its users to backup their MySQL Server databases by connecting not only directly via TCP/IP, but also via the web interface of phpMyAdmin. Now, this process allows it to work for practically every website, including with the cheapest shared hosting. Continue reading How to Automatically Backup phpMyAdmin
How to Backup MySQL to Google Drive
Considering that today Google giant provides its users with a reasonably priced storage space featuring a user-friendly interface, why not consider backing up your MySQL Backups to Google Drive. The question here is that it is not at all convenient and efficient to continue sending your MySQL database backups made with mysqldump to Google Drive manually. But don’t worry, the solution is closer than you think – try using SQLBackupAndFTP. Continue reading How to Backup MySQL to Google Drive
SQL Server Backup to Backblaze B2 Cloud Storage
With SQLBackupAndFTP you can schedule automatic SQL Server backups and send them to Backblaze B2 Cloud Storage just in a few clicks. Backblaze B2 offers affordable pricing for storing your backups: just $0.005/Gb for storage and $0.02/Gb for download. This is about 3 times cheaper than to store in Amazon S3, Microsoft Azure, or Google Cloud. Continue reading SQL Server Backup to Backblaze B2 Cloud Storage