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?– Gerard H. PilleCommented Feb 14, 2022 at 10:42
Add a comment
|
1 Answer
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:
answered Feb 14, 2022 at 9:37
