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
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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