When I setup mirroring between servers on SQL Server 2005 I use following scripts:
- SQL2K5MirroringScript-MirrorServer.sql
- SQL2K5MirroringScript-PrincipleServer.sql
- SQL2K5MirroringScript-WitnessServer.sql
These scripts rely are designed and rely on following settings:
- All servers exist in the same domain.
- The service account that is used will be domain account that has access to all three nodes.
- Scripts are designed for High Availability Mode.
- They require a central backup location to backup the database and log file to for restore.
If you need to know how to setup security using Certificates please look at Microsoft MSDN page, link.
If you need to know how to setup Mirroring accross domains, please look at MSSQL Tips article, link.
