Hi,
we are looking at your product for getting local backups of our AZURE SQL DB. We are wondering how the export affects the performance/usage of the AZURE DB that we need to be aware of and account for.
We appreciate your answer and insights,
/Michael
Hello Michael,
SQLBackupAndFTP creates backups using sqlbackage, which in turn sequentially executes SELECT queries for all tables. Therefore, the impact on performance is equivalent to running “SELECT * from all_table”, but stretched out over time due to the transfer of data over the network. However, please note that we recommend creating a snapshot for transactionally consistent exports in the “Backup options” section.
In this case, a temporary copy of the database is created in Azure during the backup process, so the impact on the original database is zero. However, there may be a slight increase in the bill for the database in Azure (for the time that the temporary backup database exists) if you are not using an elastic pool. In the case of an elastic pool, the database is created in the same pool.
If you have any other questions, please let us know.
Thank you for using SQLBackupAndFTP.
