question

RonaldoPimentelVdata-7146 avatar image
1 Vote"
RonaldoPimentelVdata-7146 asked AlbertoMorillo commented

Automatizar sql server backup do azure

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://docs.microsoft.com/pt-br/azure/azure-sql/database/recovery-using-backups
Obrigado

azure-sql-databaseazure-backupazure-automation
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @RonaldoPimentelVdata-7146 Did you had the chance to check the documentation shared by @AlbertoMorillo. Please let us know if you need more assistance.
Could you please reply in English
Regards,
Oury

0 Votes 0 ·
AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RonaldoPimentelVdata-7146 avatar image
0 Votes"
RonaldoPimentelVdata-7146 answered AlbertoMorillo commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Any question please let me know.

0 Votes 0 ·