Principal missing in sys.database_mirroring_witnesses

  • When I run SELECT * FROM sys.database_mirroring_witnesses

    on my witness server I'm seeing entries with no principal_server_name. These are for databases that no longer exist.

    The entries with the missing principal are from some testing I was doing around rolling upgrades. Any one seen this before and anyone know of a way to clean this up?

  • Found another post discussing this.. doesn't seem to have a solid answer there either.

    http://www.sqlservercentral.com/Forums/Topic982141-391-1.aspx

    One recommendation I saw there was to remove the endpoint from the witness, and then re-create it. Drawback might be that it will clear out all existing witness information, not just the NULLS.

    Basically, looks like an orphaned witness config, and dropping the endpoint might clear up the whole dmv.

    I haven't tested any of that, all speculation.

    Regards,

    Steve

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply