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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply