Azure SQL - Restore to lower enviornment

  • Hello!

    Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery if anything happens with the database in the same environment.

    But, how can we restore the production database\bacpac to lower environment without having to take manual bacpac? What can be done to monthly refresh lower environment from automated production bacpac?



  • As currently configured, to move an Azure SQL Database to on-premises, unless you're setting up a failover group (which, if you're using Managed Instance can be done), the only choice you have is a bacpac.

    Just make sure you create a copy of the database in Azure SQL Database before creating the bacpac. The reason for this is, a bacpac is not transactionally aware. This means that transactions that could result in incorrect data that occur while the bacpac is being created can negatively affect the outcome. Creating a copy of your database means that no transactions are running, so it's safe.

    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • This was removed by the editor as SPAM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply