CODEWITHSUNDEEP
azureazure-sql-database
Nayt Grochowski
Nayt Grochowski

Reputation: 591

SQL Azure - how to restore a demo database nightly?

We have a sandbox environment for clients to play in and we want to restore the database to a clean state every night.

I have not had any success in finding an example on how to set this up - easy to do this in a local environment using a SQL Agent Job - no idea how to accomplish this in Azure.

Upvotes: 2

Views: 212

Answers (1)

4c74356b41
4c74356b41

Reputation: 72171

One way to accomplish this would be ARM template and a bacpac file. Your ARM template can be deployed with PowerShell or Azure CLI using cron.

Blog Post: https://blogs.msdn.microsoft.com/kaevans/2016/03/28/deploy-bacpac-to-azure-sql-database-using-arm/

Upvotes: 1

Related Questions