Viewing the Safety Setting and State of the Witness

SELECT mirroring_safety_level_desc, mirroring_witness_name, mirroring_witness_state_desc FROM sys.database_mirroring

 

Advertisements

SharePoint: setup mirroring with Powershell

$db = get-spdatabase | where {$_.Name -eq ” database name “}
$db.AddFailoverServiceInstance(” server instance “)
$db.Update()

 

Get-SPDatabase database ID | select name, failoverserver