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 SQL Server database from a backup copy using SqlBackupAndFtp. More…
The following article will explain how to backup and restore databases in SQL Server using PowerShell. PowerShell is a very popular shell for operative systems used to automate tasks using the command line and scripts. PowerShell was created by Microsoft in Windows, but now it is supported in Linux and macOS also. More…
If any live server goes offline, an administrator has to be notified. Many companies use some third party services to do that. But what if you SQL Server service crashed for some reason? Will you be notified right away or will find out after many lost sales and transactions? What if SQLBackupAndFTP itself crashed (while extremely rare, but everything happens) – how would you know your backups are not being done?
Service down alerts option in SQLBackupAndFTP covers all of these cases. If you enable it from the main screen (see the image on the right), an email will be sent to you in the following cases:
If you need to email to multiple recipients – as usually, just separate it by a comma. You need a paid plan with Full-Service subscription to use this option.
Yandex.Disk is a 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. More…
Remote SQL backups are complicated. We will explain why and show all the available options to make the backups anyway. More…
When you encounter an issue with SQLBackupAndFTP, to understand the problem better our support team may ask you to send us the log file. This post explains how to enable the log and send it to us. More…
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. More…
Considering that today Google giant provides its users with a reasonably priced storage space featuring 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. More…
Even though Azure SQL Database provides built-in backup, you may still want to create a local copy of your Azure SQL database. This could be handy for example when you want to keep database backup copy for free longer than allowed by Microsoft Azure built-in tools which is usually 7 to 35 days, depending on your service tier. Here we will explain in details how to backup Azure SQL Database to Local Machine.
With SqlBackupAndFtp you can schedule automatic SQL Server backups and send them to Backblaze B2 Cloud Storage just in 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. More…