Managing backups for SQL Server databases can be extremely time-consuming, especially in environments with multiple servers. The need for reliable, automated solutions that support various storage destinations, such as local, cloud or network drives, is growing. So how can you streamline SQL Server backups without compromising reliability? Continue reading Automating SQL Server Data Backup
A database backup is a special copy of data that can be used to restore the database to a specific point in time. While SQL databases are quite similar in terms of their language, the tools for backup differ for different types of DBMS (Database Management Systems). In this article, we will look at how to create backups for three popular DBMS: MySQL, PostgreSQL and MSSQL Server. Continue reading Simple guide to database backups: MySQL, PostgreSQL and SQL Server
Currently, SQLBackupAndFTP has access to all files and folders on Google Drive. Soon, SQLBackupAndFTP will request access only to the files and folders on Google Drive created by SQLBackupAndFTP. Continue reading Update of SQLBackupAndFTP integration with Google Drive
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
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
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
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
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
To find these files, please follow these steps:
services.msc
Making a full database backup is very easy with mysqldump . Details are available in this article. However, such backups are a heavy load on the database because they require a lot of space and take a long time to create. This is not acceptable for a large production database. Therefore, instead of FULL database backups, you can do incremental database backups.
Incremental backups do not contain all database data but only the data that changed since the previous backup. In this case, to restore the data, you will need the entire chain of backups. Continue reading MySQL Incremental Backups on Windows