In SQL Server 2000, log shipping was available only in Developer and Enterprise Editions. Starting with SQL Server 2005, log shipping was made available in Workgroup, Standard, Developer, and Enterprise Editions. Now, in SQL Server 2012, log shipping is available in Enterprise, Standard, Business Intelligence and Web editions. Developer Edition can be used only for development purposes and not for production.
Microsoft provides a simple-to-use Log Shipping Wizard to create a maintenance plan to back up, copy, and restore the transaction log from the primary server to the warm standby server every few minutes. Log shipping has built-in monitoring that makes it easy to maintain and troubleshoot.
Log Shipping normally involves three SQL Servers: a primary server, a warm standby server, and a monitor server, as shown in Figure 26.1.