0

I need to replicate a few databases but they are too (>100GB) to use snapshot or to copy the full backup on last minute (it take around 5 hrs to copy the full backup across centers). I'm looking to see if it is possible to first restore on the subscriber the full backup and next day use the differential backup to configure the replication (from backup) is that possible? What will be the steps?

1
  • Does this mean you've never tested if your backup procedure is working? Feb 14, 2022 at 10:42

1 Answer 1

1

Yes, that's possible however you need to ensure that no full backup runs in between your last full backup and the current differential backup. If full backup runs then it should be copy only. Whenever you take full backup, the successive differential backup gets linked with that.

Differential backup contains all the changes done from last full backup. So, if you have multiple differential backup after last full backup, you need to consider only the last one and not previous ones.

Below image from Prashanth Jayaram helps in understanding:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.