Back-Up & Restore Azure SQL Server, SQL Database & Storage Account

James Daly 21 Reputation points
2021-05-17T15:00:12.533+00:00

What options are available to back-up & restore Azure SQL Server, SQL Database & Storage Account?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
43,927 questions
0 comments No comments
{count} votes

Accepted answer
  1. Pranathi Panyam_MSFT 1,066 Reputation points Microsoft Employee
    2021-05-19T12:02:53.827+00:00

    @James Daly Thank you for posting the query here!

    For Azure SQL Backup options, Please refer to the below documents :

    About SQL Server Backup in Azure VMs
    SQL backup and restore to Azure Blob storage service
    SQL Server Backup to URL

    Regarding, storage Backup - For now we do not have any option to backup the entire storage account. However, you can use RAGRS or GZRS to achieve high availability on the storage account. Please refer to Azure Blob Storage enhancing data protection and recovery capabilities

    Kindly let us know if the above helps or you need further assistance on this issue.

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

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Pranathi Panyam_MSFT 1,066 Reputation points Microsoft Employee
    2021-05-21T14:46:14.283+00:00

    @James Daly , Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

    0 comments No comments

  2. James Daly 21 Reputation points
    2021-05-24T12:00:24.9+00:00

    @Pranathi Panyam_MSFT that's perfect, I'll look into all of this. Thanks for your help.

    0 comments No comments

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.