Add Witness to Existing SQL Server Database Mirroring
1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2. Click Configure Security, Configure Database Mirroring Security Wizard welcome screen appears, click Next. 3. In the Include Witness Server dialog box, click Yes, and then click Next. 4. In the Choose Servers to … Continue reading
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working fine. We are monitor Database Mirroring by 2 ways :- 1) SSMS : Connect to Principle Server > Select Database > Right Click , Go to … Continue reading