October 7, 2010 at 2:58 pm
Here's my problem. Our company maintains a database in a foreign country that has only satellite connectivity so our connectivity FROM there is spotty. We are also limited to a single inbound port that cannot be maintained for any length of time.
I need to get the data from that system to our local reporting server on a regular basis. Hourly/daily is fine but I THINK I need to use the internet for this as a dedicated VPN isn't viable due to connectivity issues.
I'm not sure which method would be best, log shipping, mirroring, replication. I have to basically consider this to be a one way conenction, ie., a PUSH from that server to our local server.
Any ideas would be welcome.
Don
October 8, 2010 at 1:08 pm
How big is the database and how much data gets changed?
As far as I can see from your scenario, you have two ways of getting this done.
1. Log shipping. Using native compression SQL 2008 offers, the T-Logs can be FTP'd to your offshore site. The file size will probably be small.
2. Transactional replication using FTP. This is another option that can be used.
-Roy
October 8, 2010 at 1:30 pm
I would go with log shipping..It's very easy to reset a target database with log shipping because you have all the physical files available and ready to go. Replication/mirroring require initialization, and on a very spotty connection have a tendency to freeze/not restart.
October 8, 2010 at 1:45 pm
Initialization can be done using Back up. If you do not need all the tables in the publisher on the offshore DB, replication is more suited.
But like Derrick mentioned, Log shipping is easier to maintain. Keep in mind that for Log shipping, you will need to initialize the offshore with a full backup and then run the T-Logs.
Therefore in both cases you have to initialize the subscriber.
Just my 2 cents
-Roy
October 8, 2010 at 3:55 pm
All good ideas. I will look into log shipping via FTP. The database size is currently ~500 gigs and likely to grow a couple hundred more gigs before it stabilizes.
Don
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply