November 14, 2024 at 5:45 pm
Hi Team,
I am looking for a an help, Please see my problem below.
I have a Azure MI. I would like to create a replica of two production databases of size 200GB, 40GB respectively to another MI in the same region, and it is to be used for reporting workload. I would like to sync the data only once every night, real time syncing not needed.
Which of following options would best work for me ?
snapshot geo-replication or Automating backup and restore? Do you have to suggest any option, other than these two?
I know we can ADF for syncing, but which needs development efforts. I am looking for a built-in option
Thanks,
Ashru
November 15, 2024 at 3:35 pm
Since you don't need realtime, the cheapest and easiest way will be backup and restore. Nothing to it.
"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
December 10, 2024 at 6:33 pm
Thank you Grant for your suggestion. Sorry for my late reply.
Can we use the T-SQL from agent jobs to restore database from the Azure automated backups to achieve the same? so that I don't need to run the backup explicitly. If you can share any article that explain it will be very nice.
Is the Azure CLI or PowerShell only supports this activity? can I use these options from Jobs?
Thanks,
Ashru
December 10, 2024 at 8:40 pm
With Azure MI, yeah, you can restore using T-SQL. Microsoft documentation on it is pretty thorough. You will have to figure out how you want to secure your Azure blob storage, but that's in the docs too.
"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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply