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: