Different components of the Database Mirroring
To install Database Mirroring, there are three components that are required. They are as follows:
- Principal Server: This is the database server that will send out the data to the participant server (we'll call it secondary/standby server) in the form of transactions.
- Secondary Server: This is the database server that receives all the transactions that are sent by the Principal Server in order to keep the database identical.
- Witness Server (optional): This server will continuously monitor the Principal and Secondary Server and will enable automatic failover. This is an optional server.
To have the automatic ...