As far as SQL Server is concerned,
this isn??™t an ordinary TCP endpoint that you??™re configuring. It??™s specifically designated for
all database mirroring activity in and out of this instance. After using the GUI to create
the endpoint, you may want to re-create it with either a stronger or weaker algorithm
than RC4. Encryption has an obvious impact on how secure the communications are, but
also on speed: a stronger algorithm means slower communication. Consider this food for
thought??”now back to configuring mirroring.
CHAPTER 8 n DATABASE MIRRORING 217
Next, you need to configure the mirror server instance??”namely, the endpoint it??™s to
use for mirroring. To do this, you must first connect to that instance to create the database
mirroring endpoint, as shown in Figure 8-18.
Figure 8-18. You??™re configuring this on the same computer, so the mirror will simply be
another instance on this computer.
After establishing the connection to the instance holding the mirror database, you
can now create a database mirroring endpoint, as shown in Figure 8-19.
Figure 8-19. After connecting to the mirror instance (in this case, Spyglasstab\DBMirror2),
you can create a database mirroring endpoint.
Pages:
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412