Last week we implemented log shipping for the database of a web application. Every 15 minutes a transaction log backup is made and copied to a server in a data center in a city 70 kilometers away.
On that server the transaction log backup is restored to a database that stays in the restoring state. In case of an emergeny we can failover to this data center in a matter of minutes.
Basically we just followed the log shipping wizzard (I know, we could script it as well) and after that most time was needed for documenting the steps to perform the failover.
posted @ Sunday, February 21, 2010 3:27 PM