question

MSTechie-7364 avatar image
1 Vote"
MSTechie-7364 asked Prrudram-MSFT commented

Secure DB2 backup on azure vm

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-backup
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Prrudram-MSFT avatar image
0 Votes"
Prrudram-MSFT answered Prrudram-MSFT commented

Hello @MSTechie-7364,

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://docs.microsoft.com/en-us/azure/backup/backup-sql-server-database-azure-vms#create-a-recovery-services-vault
https://docs.microsoft.com/en-us/azure/backup/backup-azure-sql-database

Adding the link for restore workflow with SQL DB backups https://docs.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.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, are you saying that we can we configure db level backup for DB2 database to recovery vault?

Any link would be useful

0 Votes 0 ·

Hello @MSTechie-7364,

yes, you can we configure db level backup for DB2 database to recovery services vault. I have added the links in the above answer already

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

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

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.


0 Votes 0 ·

Hi @Prrudram-MSFT

The links that you gave , talk about backing up SQL database

My question was backing up DB2 database

Please help

0 Votes 0 ·
Show more comments