Contents
How do I know if mirroring is working?
To view the status of a database mirroring session Right-click the database, select Tasks, and then click Mirror. This opens the Mirroring page of the Database Properties dialog box. No database mirroring session exists and there is no activity to report on the Mirroring page.
What is principal synchronized in SQL Server?
During a database mirroring session, the mirrored database is always in a specific state (the mirroring state). At the start of a database mirroring session, the database is in the SYNCHRONIZING state. The principal server is serving the database, and the mirror is trying to catch up.
How to use database mirroring monitor in SQL Server?
The dbmmonitor system stored procedures can be used as an adjunct to the Database Mirroring Monitor. For example, even if monitoring was configured using sp_dbmmonitoraddmonitoring, Database Mirroring Monitor can be used to view the status.
What is the status of a mirror server?
The principal server instance is sending log records to the mirror server instance, which is applying the changes to the mirror database to roll it forward. At the start of a database mirroring session, the mirror and principal databases are in this state. Icon: Standard database cylinder, status Synchronized.
Where is database mirroring status stored in MSDB?
Database mirroring status is stored in an internal, undocumented database mirroring status table in the msdb database. This status table is automatically created the first time the mirroring status is updated on the server instance.
How to send email alerts for SQL Server mirroring?
Substitute in the below script your Database Mail profile and a suitable email address to receive the alerts. SET @string = ‘Host: ‘ + @@servername + ‘.’ + CAST ( DB_NAME ( @DbId) AS VARCHAR )+ ‘ – DB Mirroring is ‘ + @state + ‘ – notify DBA’ –also alert if there is no mirroring just in case there should be mirroring 🙂