• Yes. If you are going to get granular and define only certain tables then you would need to use transactional replication. The are quite a few considerations and you should really read BOL to get an understanding of all this prior to starting. Once you get that and have a plan mapped out feel free to reply and or create a new post with questions, etc.

    Additionally, if this is a bulk-load type process that is updating your primary server, you could actually run the same process against the other server as well. Not sure if that is possible in your scenario.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot