Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

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 shipping in a database mirroring environment.

Getting ready

For the prerequisites to install database mirroring, please refer to the Implementing database mirroring features and performance enhancements recipe. In order to configure the log shipping...