Database Reference
In-Depth Information
How to do it...
The following steps are required to implement the database mirroring features and
performance enhancements using SQL Server 2008 R2.
1. The Configure Database Mirroring Security Wizard automatically creates the database
mirroring endpoint (if none exists) on each server instance, and enters the server
network addresses in the field corresponding to the role of the server instance
(Principal, Mirror, or Witness).
2. To configure Database Mirroring, in Object Explorer click the server name to expand
the server tree and expand Databases to select the databases to be mirrored.
3. Right-click the database, select Tasks and then click Mirror to open up the Mirroring
page of the Database Properties screen.
4. To begin configuring the mirroring process, click the Configure Security to launch the
Configure Database Mirroring Security Wizard.
5.
The wizard automatically creates the database mirroring endpoint (in our case,
tcp://DBIASSQA:5022
) on each server instance and enters server network
addresses in the field corresponding to the role of the server instance as Principal,
Mirror, or Witness.
6.
In continuation to the Implementing Availability feature enhancements recipe steps,
the last step in the Configure Database Mirroring wizard is the Security. Click Next to
see a summary of choices made in the wizard, then choose Finish to configure the
mirroring session.
7.
The next screen provides you with the command buttons Start Mirroring or Do Not
Start Mirroring. Select Start Mirroring immediately.
Search WWH ::
Custom Search