Database copy for report work load

  • 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

Viewing 0 posts

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