Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
System catalog views
| 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 views
| 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 tables
| 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. |