Secure DB2 backup on azure vm

Question

We have DB2 on azure vm, which we are backing to recovery vault and hence secure.i am aware that VM backup is secure.
Is there any option to securely backup DB2 database outside azure vm, like DB2 database backup

Answer 1

Hello @MS Techie ,

Thank you for reaching out to the Microsoft Q&A platform. Happy to answer your question.

As per your verbatim, I understand you have configured VM level backup for the SQL VM hosting the database DB2. Additionally if you want to configure DB level backups, you can do it with azure recovery services vault itself. The DB backups will run on a separate schedule you specify. Just like traditional SQL native backup, you can configure DB backups and Transactional logs backup with different backup frequency.

Note: You could use an existing recovery services vault or a new one to create these DB level backups.

For detailed information, I would recommend you to go through the below links
https://learn.microsoft.com/en-us/azure/backup/backup-sql-server-database-azure-vms#create-a-recovery-services-vault
https://learn.microsoft.com/en-us/azure/backup/backup-azure-sql-database

Adding the link for restore workflow with SQL DB backups https://learn.microsoft.com/en-us/azure/backup/restore-sql-database-azure-vm

Hope this helps. Feel free to reach out for any further queries.

Please "Accept as Answer" and Upvote if the answer provided is useful, so that you can help others in the community looking for remediation for similar issues.