Chapter 20. Administering and Managing Log Shipping

Log shipping is one of four SQL Server 2005 high-availability alternatives. Other SQL Server 2005 high-availability alternatives include database mirroring, failover clustering, and peer-to-peer replication. Database mirroring and peer-to-peer replication are new technologies introduced with SQL Server 2005 and are discussed in other chapters within the book.

What’s New for Log Shipping in Service Pack 2?

The SQLLogShip.exe application is now supported in SQL Server 2005 Server Pack 2. This command-line application performs all the different log shipping processes such as initiating the transaction log backup on the primary server, copying the transaction log backups to the staging area, and ...

Get Microsoft® SQL Server 2005 Management and Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.