Secure DB2 backup on azure vm

MS Techie 2,686 Reputation points
2022-04-19T10:39:54.773+00:00

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

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,515 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Prrudram-MSFT 22,976 Reputation points
    2022-04-19T11:38:32.82+00:00

    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.