question

BevilacquaEnrico-8039 avatar image
0 Votes"
BevilacquaEnrico-8039 asked SadiqhAhmed-MSFT commented

How to restore a database from Recovery Service Vault

Hello there,
I have several databases backed up in a Recovery Services Vault.
When I try to restore a database in the blade I select the following:

Backup Item --> BACKUP MANAGEMENT TYPE -->SQL in Azure VM -->

I get a list of all of the backed up databases. When click on an Item from the column Instance or AlwaysOn AG the following page is blank.

I would like to know there's some wrong or missing configuration and where I have to check to run the restore.

Thank you.

azure-backup
· 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.

@BevilacquaEnrico-8039 Thank you for reaching out to us!

The steps you mentioned is as per the documentation - https://docs.microsoft.com/en-us/azure/backup/restore-sql-database-azure-vm
You may want to try restore operation using PowerShell - https://docs.microsoft.com/en-us/azure/backup/backup-azure-sql-automation#restore-sql-dbs and let me know if that works.

Also share the screenshot of the issue you are observing for restore through Azure portal.


If the response helped, do "Accept Answer" and up-vote it.

0 Votes 0 ·

113228-az-001.png



Here is the screenshot that I get when I try to restore a database through Azure portal.

0 Votes 0 ·
az-001.png (12.9 KiB)

Ok thank you, problem solved.

0 Votes 0 ·

@BevilacquaEnrico-8039 Thank you for the update. Glad to know the issue is resolved.

Kindly accept the post as answer and up-vote it.

0 Votes 0 ·

1 Answer

SadiqhAhmed-MSFT avatar image
0 Votes"
SadiqhAhmed-MSFT answered

@BevilacquaEnrico-8039 Most probably you are clicking on the AG or SQL instance name link, which will take you to that blade regarding auto-protection, if you click anywhere else on the same line, it should take you to where you want.


If the response helped, do "Accept Answer" and up-vote it.

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.