October 2010
Intermediate to advanced
1008 pages
46h 16m
English
There are two steps to the mirroring process. The first is to set up a security relationship between the principal server and the mirror server. The second step is to actually configure the mirror itself.
By right-clicking the source database (on the principal SQL instance) and choosing properties, and then selecting the Mirroring node in the navigation pane, you get the dialog box shown in Figure 17.6. Note that the mirroring options are grayed out. Click Configure Security to set up the relationship between the principal instance and the mirrored instance. This wizard also allows you to choose whether there will be a witness server.
Figure 17.6. Beginning the process to configure security for the ...
Read now
Unlock full access