How to Automatically Backup phpMyAdmin

full backup, sql backup job, Uncategorized

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

full backup, how to backup, Uncategorized

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 →

How to backup Azure SQL Database to Local Machine

Database Backup, SQL Server, sqlbackupandftp, , , , , ,

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 are usually 7 to 35 days, depending on your service tier. Here we will explain in detail how to backup Azure SQL Database to a Local Machine.

Continue reading How to backup Azure SQL Database to Local Machine →

SQL Server Backup to Backblaze B2 Cloud Storage

full backup, SQL Server, Uncategorized

backblaze logoWith 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 →

How to automate SQL Server database backups

Database Backup, full backup, sql backup job

The question “How to automate SQL Server database backups” has several answers and here we will review all of the best options. But first, let’s define what SQL Server database backup automation stands for. SQL Server backup automation is a process that includes at least the following steps:

    1. Run SQL Server backup for selected databases on a schedule
    2. Compress & encrypt the backups
    3. Upload the backup to a remote destination – network, NAS, FTP on one of the cloud storages (Dropbox, AWS, OneDrive, SkyDrive, etc..)
    4. Send email notification on backup success or failure

The most popular SQL Server backup automation options that we review here are:

SQLBackupAndFTP
Microsoft SQL Server Management Studio & SQL Server Agent
T-SQL
Ola Hallengren script
or you can just jump straight to the Conclusion

 

Continue reading How to automate SQL Server database backups →

How to Backup SQL Database Automatically Using SSMS

Database Backup, sql backup job, SQL Server

If you are looking for a tutorial on how to backup SQL database automatically with SSMS just follow the instructions below. Note however that there are better ways to backup SQL Server database than SSMS. This is especially true when you are running MS SQL Server Express that lacks SQL Server Agent – just use SQLBackupAndFTP instead of the method below.

Continue reading How to Backup SQL Database Automatically Using SSMS →

How to backup remote SQL Server database using SQLBackupAndFTP

Database Backup, full backup, sqlbackupandftp

You can run scheduled backups of a remote SQL server using SQLBackupAndFTP. The standard BACKUP DATABASE command would not work on a remote SQL Server, so scripts would be the only option. Scripts are not as good as *.bak files because they are larger, do not support differential backups, and should be used only if you do not have an option to create *.bak files. If you want to know more – read a good explanation of why remote SQL backups are such a pain. Continue reading How to backup remote SQL Server database using SQLBackupAndFTP →

Backup SQL Server on the network

differential, sql backup job, Uncategorized

SQLBackupAndFTP creates standard *.bak files when it runs locally on the same computer where SQL Server is. For remote SQL Server computer backups SQLBackupAndFTP creates backup script files (*.sql). Whenever possible, you should always opt for *.bak backups against *.sql backup files.

Here we will show you how to backup a SQL Server on the network to the standard *.bak file even when SQLBackupAndFTP runs on a different computer from where the SQL Server is. The main requirement, in this case, is that both SQL server and SQLBackupAndFTP have access to the same shared network folder.

Continue reading Backup SQL Server on the network →