Mirroring: Fixing/Removing/Recreating/Pausing/Querying
Start/Stop Mirroring EndPoints: ALTER ENDPOINT Mirroring STATE = STOPPED ALTER ENDPOINT Mirroring STATE = STARTED select * from sys.endpoints; select * from sys.database_mirroring_endpoints; SELECT d.name as 'td','', mirroring_state_desc as 'td','', mirroring_role_desc as 'td','', mirroring_partner_instance as 'td','', mirroring_role_sequence as 'td','', case (m.mirroring_witness_state_desc) when 'Unknown' then 'No Witness Server Configured' else m.mirroring_witness_state_desc end as 'td','' , case(m.mirroring_witness_state_desc) when 'Unknown' then 'No Witness Server Configured' else m.mirroring_witness_name end as 'td','', log_reuse_wait_desc as 'td','' FROM sys.database_mirroring M inner join SYS.DATABASES d on m.database_id = d.database_id WH...