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.