Unsolved
This post is more than 5 years old
2 Intern
•
2K Posts
0
361
July 18th, 2007 11:00
Replistor on WAN
Replicating on WAN could b a problem due to bandwidth issues.
Is it possible to backup data on tape from one site, restore it on the other site and then perform replication between the two sites.
Ex. SQL database from City A is backed up & restored in City B. Then, replistor is set to replicate the database from City A to City B. Would this do only an incremental replication or would it do the complete full replication again.
We want to avoid replicating on WAN using replistor.
Is it possible to backup data on tape from one site, restore it on the other site and then perform replication between the two sites.
Ex. SQL database from City A is backed up & restored in City B. Then, replistor is set to replicate the database from City A to City B. Would this do only an incremental replication or would it do the complete full replication again.
We want to avoid replicating on WAN using replistor.
No Events found!


dramjass
151 Posts
0
July 23rd, 2007 11:00
Your solution to restore the DB from tape is a possible work-around then having to replicate all the data across the WAN and is a typical way of handling this.
Or, you can also do the following:
1. Bring the target box local and perform a Full Sync in the local LAN.
2. Use a USB drive to copy the data and ship it to the Target site.
After the largets portion of the file is on the Target box, then an Inc Sync can be performed to compare the Source and Target data. RepliStor will only send the updates to the DB.
NOTE: Try to minimize the time between getting the data to the Target and performing the Inc Sync. If there are a significant amount of changes to the Source side, the Sync could potentially revert to a Full if the service determines there are too many changes. This is not likely, but some thing to be aware of.