Database mirroring stuck in suspended mode We have an issue with database mirroring on one of the databases on our sql instance where mirroring is suspended for almost 15 hours now.

DB is 200 GB on SQL server 2008R2 Sp3+cu with latest patched done for meltdown.

so far we have done below


Rebuild the endpoints--> no luck
Resume the mirroring with partner resume --> no luck
DBCC CHECKDB shows 0 errors found on either side.


Nothing found from error logs on Principal. However on secondary when we resume error logs seems to have stack dump logged every time.

Any help on how to resume the suspended mirror apart from rebuilding mirroring from scratch?
First thing to try:
ALTER DATABASE Gandalf SET PARTNER RESUME;

Might work!  If you prefer you can do it with the GUI - Tasks / Mirror / Resume
Check logs for an Error 3624.
I get this occasionally - reading up on this, it looks very much like &quot;an error has occurred.&quot;
My solution is to stop mirroring and recreate.
I would be interested if anyone has better information.