Replication a large DB

  • I have a DB and the final size will be 100GB one year later, it need to be replicated. Which replication log shipping, transactional replication or any other is better? Thanks.

  • Not a simple question! A lot of it depends on what you're going to do with the other server. Both are pretty easy to set up. If you'll tell us more about what you're planning, maybe we can give you better advice.


  • Two DBs will be located in two different regions and connected over WAN link. The destination DB for query only, services 6x24. I have no detail plan yet, now I am headache in performance, recover and normal support.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply