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...
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