In-Depth Tour de SQL Finale, Part IV: Replication Our final sprint to the finish line stretches over replication: its limitations, high availability and the many improvements since the last version.

I'm looking for some insight into implementing replication with a SQL 2005 Standard database based on our needs as well as the fact that one major replication type is deprecated in SQL 2012 and ...

We are, however, mirroring the database within site 1. We are not mirroring at site 2. I'm thinking merge replication might be better than transactional with queued updates.

Database replication from the head office to various branches to reduce bandwidth usage or speed up database requests. Database replication to offer load balancing in all instances. This can be ...