we need to copy a backup file between two very slow network Data centers (transfer rate: 350 kbps),
Our full bak file around 200 GB is taking around 9 days to copy to the other side. Tape transfer is also not possible between this location.
My question is how to Recover the DB on the other side after 9 days lag,
Database Recovery Model: Full
Full backup size: 200GB
Differential backup file is 15 GB every 4 hours,
Transactional log backup for every hour is around 200MB,
why is it so, when the full backup is 200gb and Differential backup is 15GB each,
what is the best i can get the data to the other side? how to minimize the Diff/transaction backup size or remove them and get one or two t-log backups with min size.
Any Suggestions will be of great help.