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
Category Archives: full backup
How to automate SQL Server database backups
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:
-
- Run SQL Server backup for selected databases on a schedule
- Compress & encrypt the backups
- Upload the backup to a remote destination – network, NAS, FTP on one of the cloud storages (Dropbox, AWS, OneDrive, SkyDrive, etc..)
- 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 remote SQL Server database using 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