Home Forums SQL Server 2005 Administering Mirroring In sql server 2005- Witness Full Quorum RE: Mirroring In sql server 2005- Witness Full Quorum

  • Hi there,

    If you run:

    select * from sys.database_mirroring

    on the Principal and the Mirror, check the following values. For a normal, synchronised mirror with Witness, the values should be:

    -- mirroring_state = 4 (synchronized)

    -- mirroring_role = 1 (principal) or 2 (mirror)

    -- mirroring_witness_state = 1 (connected)

    That should be enough for you to work out where your problem lies.

    Andy