Just to add, the mirroring mode is high safety without automatic failover.
When I run this query
SELECT mirroring_witness_name, mirroring_witness_state FROM sys.database_mirroring
mirroring_witness_name mirroring_witness_state
0
0
0
0
0
mirroring_witness_state of 0 = Unknown and mirroring_witness_name NULL = No witness exists.
Here, mirroring_witness_name is blank. What does this imply. Does it mean that there is no witness.
Can I safely assume the operating mode is high safety without automatic failover.
Please let me know.