All posts by Alex

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 →

Dropbox has stopped the support of API v1

sqlbackupandftp, version

If you use the old versions of SQLBackupAndFTP v 10 or lower and send backups to Dropbox, then starting from June 28, 2017 (update: Dropbox have extended the API v1 cutoff date until September 28th, 2017), you will see the following error message:

"Sorry, Dropbox has stopped the support of API v1. Please upgrade to the latest version of the application to work with the new Dropbox API."

The reason is that on that date Dropbox has turned off API v1 and older versions of SQLBackupAndFTP can not work with the latest Dropbox API. As a result, there is no way to send backups to Dropbox using SQLBackupAndFTP v10 or lower.

If you plan to continue sending backups to Dropbox, please upgrade your license to the latest version of SQLBackupAndFTP v11 that supports all of the latest APIs.

How to migrate to SQLBackupAndFTP 11 from the previous versions

password, sqlbackupandftp, version

SQLBackupAndFTP v11 is a culmination of years of work and our SQL backup experience with close to 1 million installations of the earlier versions. It is significantly better than the previous version in every respect (or anything else on the market). Read SQLBackupAndFTP v11 – What’s New? or How SQLBackupAndFTP 11 differs from the previous versions?

If you have used the previous versions of SQLBackupAndFTP we strongly suggest migrating to v 11. Continue reading How to migrate to SQLBackupAndFTP 11 from the previous versions →

How to backup Azure SQL Database to Local Machine

Database Backup, password, sqlbackupandftp

Being a managed cloud database Azure SQL Database provides built-in functionality for automatic database backups. It allows you to restore your database to any point in the past and those backups are kept in reliable geo-redundant storage. So why do we need other tools like SqlBackupAndFtp to backup of Azure SQL Database? This can be the case when you need to get a copy of your database locally, outside Azure infrastructure. In this post, you can find a step-by-step guide on how to backup the Microsoft Azure SQL Database with the help of SQLBackupAndFTP.

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

SQLBackupAndFTP v11 – What’s New?

differential, network drive, sqlbackupandftp

Have you seen our brand-new version 11 of SQLBackupAndFTP?  If yes, then you have also noticed that its looks and feels very different from its predecessor (compare features in the new & old versions). That’s right – this release is built from scratch based on our eight-year experience creating SQL Server backup software and close to 1,000,000 installations of the previous versions.

If you have used the old version, this post will help you to quickly grasp the main points that make the new version better. If you are new to SQLBackupAndFTP, you can read this as a quick introduction. Continue reading SQLBackupAndFTP v11 – What’s New? →

How Tos – SQLBackupAndFTP

amazon, network drive, sqlbackupandftp

Licensing

Database Backups

Backup Storages

Database-related settings

Security & Reliability

Errors