Forum Discussion

Santosh20's avatar
Santosh20
Copper Contributor
Feb 15, 2024

How to restore file from Azure recovery service vault

Hi ,

 

I have SQL installed on Azure VM and being backed up by Azure so the backup files are stored in Azure Recovery Service vault. I have requirement to restore the DB in SQL managed Instance and so if anyone can suggest me what would be best method to restore DB in managed instance.

 

I was thinking to restore as file in blob container and from there restore the DB in managed instance but I have no idea how to restore file in Azure blob container. Please suggest

1 Reply

  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    Apr 08, 2024

    Santosh20 

     

    Can try this:

     

    RESTOREDATABASE [YourDatabase Name] FROM URL = 'https://[YourStorage Account].blob.core.windows.net/YourContainer Name/Your Backup File Name.bak' 
MOVE '[YourData File Name]' TO '[YourData File Path]', 
MOVE '[Your Log File Name]' TO '[Your Log File Path]'

Resources