Robert Davis (7/17/2012)
There is also a bug related to this (though I don't know if a KB has been published Try stopping and starting the mirroring queues to see if it resolves the problem. If not, continue investigating and consider opening a case with PSS.
Thank you for the suggestion.
Do you mean suspend and resume the mirroring session?
I will try that next time this happens.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]