Azure SQL DB: Programmatic Backup and Restore

Question

I am working on an automation infrastructure for an Azure based product. I need the ability to programmatically (no manual UI intervention work allowed) backup and restore an Azure SQL DB. I am looking for the appropriate RESTFul api's but don't see any that fit the bill. Perhaps I missed it ??

Any pointers would be appreciated.

Not exact thing i came across till now. but you can refer something like this(all are in preview mostly). learn.microsoft.com/en-us/rest/api/sql/2021-08-01-preview/… — lokanath das
– lokanath das, Commented Apr 7, 2022 at 10:57

Utkarsh Pal · Accepted Answer · 2022-04-08 07:47:51Z

1

To Export (Backup) the Azure SQL Database, you can use the below HTTP POST request.

POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/export?api-version=2021-02-01-preview

To know about the URI parameters required in above request, go through this Microsoft official document.

For Restore, you can use Azure PowerShell or the REST API. There are some PowerShell commands you need to learn to accomplish this task. Learn about these commands here Restore-AzSqlDatabase.

Useful link: Programmatic recovery using automated backups

answered Apr 8, 2022 at 7:47

Utkarsh Pal

4,5781 gold badge8 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Utkarsh Pal Over a year ago

Hey @Walter!, has it solved your problem; else can you share more details so I can troubleshoot the issue?

Collectives™ on Stack Overflow

Azure SQL DB: Programmatic Backup and Restore

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related