March 20, 2023 at 4:20 pm
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?
Thanks.
March 21, 2023 at 12:58 pm
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
March 22, 2023 at 6:56 am
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