Summary

Log shipping is an extremely flexible and compelling option as a primary or secondary method of availability with SQL Server. It is a proven solution with a good track record. From an implementation and cost perspective, log shipping provides one of the best methods of protection for your databases. It overcomes the distance limitations that are inherent in most clustered solutions, and it is based on standard SQL Server processes like SQL Server Agent jobs, DTS, and backup and restore. As with any high availability technology, it comes with its caveats, and it is not the best solution for all environments.