This is the final part of database mirroring, and here I want to give you some nice tips and also some links to get you a little bit further.
First of all. Showing you the videos are very easy, because I am used to do this. When you start working it can be a challenge for you, but I suggest that you setup a virtual machine and do a snapshot once in a while.
When setting database mirrorring up in a production environment, then be aware of the following:
- Security. I did just click next –> next –> next, but you must think about security, and eventhough it is irritating, then make sure that you think about the principle least privileged.
- Endpoints must be configured correctly. Do you need encryption? (yes of course ), what ports are you going to use and what credentials are you using?
- Make sure that ports are open in the firewalls for the ports you are using.
- Do we need high safety or high performance.
- Do we need automatical failover or not?
If you want to learn more about database mirroring, then I can recommend the following link:
if you get into troubles, then I would suggest:
That was the final step in this survival kit for Database Mirroring.