Sql-server – Database mirroring stuck in suspended mode

mirroringsql serversql-server-2008-r2

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

  1. Rebuild the endpoints–> no luck

  2. Resume the mirroring with partner resume –> no luck

  3. 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?

Best Answer

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 "an error has occurred."

My solution is to stop mirroring and recreate.
I would be interested if anyone has better information.

Related Question