| title | Database mirroring system object reference |
|---|---|
| description | See information about database mirroring system objects: system catalog views, system dynamic management views, and system tables. |
| author | MashaMSFT |
| ms.author | mathoma |
| ms.date | 03/14/2017 |
| ms.service | sql |
| ms.subservice | database-mirroring |
| ms.topic | conceptual |
[!INCLUDE SQL Server]
| System catalog view | Description |
|---|---|
| sys.database_mirroring_witnesses | Contains a row for every witness role that a server plays in a database mirroring partnership. |
| System dynamic management view | Description |
|---|---|
| sys.dm_db_mirroring_auto_page_repair | Returns a row for every automatic page-repair attempt on any mirrored database on the server instance. |
| sys.dm_db_mirroring_connections | Returns a row for each connection established for database mirroring. |
| System table | Description |
|---|---|
| sysdbmaintplan_databases | Returns information about database mirroring maintenance plans. |
| sysdbmaintplan_history | Returns information about the history of database mirroring maintenance plans. |
| sysdbmaintplan_jobs | Returns information about database mirroring maintenance plans jobs. |
| sysdbmaintplans | Returns information about database mirroring plans. |