Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a database (source) located at a place, where data transfers are expensive. We need to have a duplicate of this DB (target) locally, and make sure it gets updated with recent data once a day. The source DB is large, and require that we setup the local (target) DB from a backup from the source DB first, because it would be very expensive to transfer all data over the net first.

Should I like into MS SQL Service Broker or DB mirroring?

share|improve this question
    
How big is "large"? Can you not just backup source and restore to target once / day? –  squillman Jan 16 '12 at 15:17
    
DB is approx. 65GB and is located in another country. The price for datatransfers from there are enormous, so I need to figure out how to keep a consistent copy of it and only update changes. Perhaps I could look into how to setup a replication, if it's possible to first setup the target db from a backup. –  joeb Jan 16 '12 at 15:26
    
Ah right, sorry. I was thinking "local" = local to the source db. (Monday morning for ya). Any stats for how much data is modified daily? –  squillman Jan 16 '12 at 15:28
    
probably no more than 100MB daily. –  joeb Jan 16 '12 at 15:33
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.