CODEWITHSUNDEEP
azure-sql-database
iasksillyquestions
iasksillyquestions

Reputation: 5689

Azure SQL database snapshot

I have Azure SQL database. Before updating it (schema) as part of a dev ops pipeline, I'd like to take a snapshot so should the worst happen I can roll back.

Imagine my dismay when I discovered that snapshots aren't available for Azure SQL database.

What's the best practice here?

Upvotes: 2

Views: 1671

Answers (1)

Conor Cunningham MSFT
Conor Cunningham MSFT

Reputation: 4501

The moral equivalent you can do in SQL Azure is:

  • start an active geodr to the same region
  • let it seed and catch up
  • break the replication at the point to which you want the option to roll back in case of problems in your dev ops change.

This avoids the time to do a PITR restore (but you pay for the extra database for the duration it is alive).

Upvotes: 1

Related Questions