O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing Log Shipping scenarios in a Database Mirroring environment

Log shipping has been part of SQL Server as a core standby feature (backup and restore), but it is also considered a high-availability feature. However, it cannot be matched to failover clustering or database mirroring feature.

Like database mirroring, the log shipping feature includes database level protection with no automatic failover option. It is also possible to implement log shipping in a database mirroring environment, as both features complement the log sequence number to function.

The SQL Server 2008 R2 high-availability feature enables the database to perform mirroring and log shipping simultaneously. In this recipe, we will go through the required steps to manage log ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required