SQL Replication

Replication VS Mirroring, and what to use for a Disaster Recovery setup

One question I seem to get asked a lot is what is the difference between Replication and Mirroring when it comes to SQL, and especially for the Sys Admin stuck in the middle, what is the best one to use for a Disaster Recovery scenario. Firstly, for people who haven’t heard of either, both replication

Replication VS Mirroring, and what to use for a Disaster Recovery setup Read More »