Search This Blog

Sunday, December 15, 2019

How to Backup Azure SQL Database to Local - Part 3

Continue from Part 2, we are going to explore next tool to backup Azure SQL Database to Local Computer.

Tool 3: SqlBackupAndFTP Tool

Able to download this tool from here. It is provided free to backup 2 database.

It support MS Sql, My SQL and PostgreSQL database. This tool allow you to backup SQL database to Bacpac file with scheduling for full, differential & transaction.



You can use wizard to configure the backup. Start by selecting type of database.


Next step, enter Azure SQL Server name & credential


Once connected, select database that you want to backup.


Then select your backup target location. For our scenario, we select "Local"


Specify the schedule that you want to backup. You can click on Settings to change the schedule to advance mode.


Finally to get the result, we can send notification via email.


[Result] 
Backup will run according to schedule. You can view the status from log.




That's all for today.

Click here for Part 4.