Replicate specific data on Sql Server standard.

  • Environment:

    2 boxes mirrored with MSSQL Server 2104 Standard and they need to be up 24x7.

    problem : I need to break the mirroring to rebuild offline the indexes on Database B while Database A receives transactions.

    After the index rebuild is done I need to put the missing transactions posted on A to the B server and then point the application to Database B. Now A won't be in sync. for that I'll take a backup of B and restore it on A so they will be in sync with mirroring.

    For that to happens i need to answer this question. ?

    How can i capture the missing transactions from A to post to B ?

    Will table replication help on this matter or what could be the best method.

    Thanks for your time.

Viewing 0 posts

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