Posted on 1999-06-29
I'm new to the MS SQL DB world, and I need some recommendations. I'm involed in the designing of a site where we would like to place two SQL7 DBs on two machines. The DBs have to be a copy of each other, for redundency and performance. The questions are:
1. I heard that the SQL7 comes with tools for mirroring / replication, but they are not the best out there. What other options are there (3rd parties) and which is the best (cost/perf, prices)?
2. Should we perform transactions on both machines and have them constantly synchronizing, or would it be better to do that on one of them and have the second DB tracking that one all the time (what would gain better performance? relaibelity?).
Thank you in advance.