Share via

Automatizar sql server backup do azure

Ronaldo Pimentel - Vdata 26 Reputation points
2021-06-07T15:54:07.177+00:00

Olá!
Tenho alguns serviços de aplicativo rodando no azure juntamente com a hospedagem do banco de dados.
Sei restaurar o banco para um "ponto no tempo" pelo portal.
Desejo criar uma automação para que possa fazer backup para armazenamento externo ou subir esse backup entre os recursos existentes no tenent.
Podem me passar algum conteúdo ou material para executar esta tarefa?
estou utilizando o material oficial, mas não achei isso em específico.
https://learn.microsoft.com/pt-br/azure/azure-sql/database/recovery-using-backups
Obrigado

Azure Backup
Azure Backup

An Azure backup service that provides built-in management at scale.

Azure SQL Database
Azure Automation
Azure Automation

An Azure service that is used to automate, configure, and install updates across hybrid environments.


Answer accepted by question author

Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator
2021-06-07T17:30:13.707+00:00

You can use Azure automation to backup (export as bacpac) your database periodically to an Azure Storage Account. You can download the sample script from github. Please see Azure Automation Overview for more details about Azure Automation.

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Ronaldo Pimentel - Vdata 26 Reputation points
    2021-06-09T19:44:13.197+00:00

    Thanks Alberto, I'm learning about it to deploy.

    Was this answer helpful?


Your answer

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