Log Shipping

Recently I had to implement log shipping as a HA strategy for a set of databases which were originally running under the simple recovery model. Actually, the databases were subscribers for a merge publication, which leaves database mirroring out of the possible HA options. Clustering was not an option either, due to lack of shared storage at the subscribers. After turning all databases to full recovery model and setting up log shipping, I started to wonder if there was a better way to implement it. [Read More]