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

Implementing Database Mirroring features and performance enhancements


Database mirroring involves re-applying every modification operation that occurs in the primary database onto the mirror database. The physical log record is applied to the mirror database and keeps an exact copy of the primary database.

SQL Server 2008 provides many enhancements that are related to the performance of database mirroring. In this recipe, we will go through the important steps required to implement database mirroring features and performance enhancements using SQL Server 2008 R2.

Getting ready

To setup and configure the database mirroring environment, ensure the following requirements are met:

  • All the server instances are on the same level of service packs and hotfix packages for the Windows operating system and SQL Server services.

  • Ensure that the SQL Server edition is DataCenter, Enterprise, or Standard.

  • When any of the database mirroring partners is using Standard Edition (SE), then the other partner must be...