Share via

Azure Recovery Vault Services SQL restore as files - just copy the newer files

Rigg, Bruce (Reigate) 21 Reputation points
2021-06-02T17:08:58.423+00:00

We need to daily take copies of Prod databases into our Non-prod environment.
As these are different subscriptions we are doing Restore As Files from the prod recovery vault to a VM and then copying the .bak files to the non-prod environment and restoring there.
As we have weekly full backups and daily differentials we only really need the latest daily differential and subsequent log backups.
However if we do not clear the target folder we get error
Restore as files failed because one or more files with the same name already exist in the target folder.

It would be good if there was a way to say skip files with matching names so that only a days worth of data needs to be copied which hopefully would be much quicker.

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,496 questions
0 comments
Accepted answer
  1. SadiqhAhmed-MSFT 49,331 Reputation points Microsoft Employee Moderator
    2021-06-04T14:28:34.543+00:00

    @Rigg, Bruce (Reigate) Thank you for reaching out to us!

    As of today, if you restore files, you will get the entire chain (Fulls + differentials + logs). So, the ask is “Allow me to skip fulls because I already have it. I don’t require all differentials, only the latest one and subsequent log backups”, right?

    The final solution could be “skip files with matching names” or “Just give me data from X to Y time or for current day, last 2 days etc…”

    This is a good feature request. Might I ask you to leave your valuable feedback here - https://feedback.azure.com/forums/258995-azure-backup this would help the concerned team to review this request and plan on adding this functionality and get back with delivery timelines.

    ----------------------------------------------------------------------------------------------------------------------

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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.