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. More…
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:
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
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.
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. More…
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.
This post will give you a bird’s eye view explanation of what “cloud database” is and what kinds of cloud databases the market offers us today. More…
If you’re looking for a promo code for SQLBackupAndFTP you can use the following one:
SBF10OFF
It will give you 10% off all editions of SQLBackupAndFTP.
This step-by-step guide helps a user having a Microsoft Azure account to create Microsoft Azure SQL Server on Linux (Ubuntu) (free license) and to use the SQL Server on Ubuntu with an SSH terminal. More…
We were scammed out of a few thousand dollars last month by a fake “affiliate”. Here’s how. More…
By default SQLBackupAndFTP stores backups in file names like DatabaseNameYYYYMMDDHHMM.zip (eg Pubs201801011120.zip). But you can also use custom file names if you have such needs More…