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.
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...