1

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?

  • Can you check windows event logs ? Also, can you post a pic / or text of core dump. – Kin Shah Apr 4 '18 at 14:11
  • Were you able to solve your issue? What was the cause of it? – andrews Dec 27 '18 at 9:15
  • @andrews: There was bug in SQL for code being called by app making mirror suspended as per the case opened with MS. No other alternative but to build or set up up mirroring from scratch – BeginnerDBA Jan 7 '19 at 15:09
  • Interesting...thanks for the update. Is there a public case ID to read the details of the bug? In my case it appeared that mirroring become suspended because of lack of disk space on the mirror server to accept the full set of changes from the principal. After I freed up disk space on secondary server and resumed mirroring it got synchronized successfully. – andrews Jan 8 '19 at 9:51
0

First thing to try:

ALTER DATABASE gandalf SET PARTNER RESUME;

Might work!

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.

| improve this answer | |
-1

Sometimes this works: 1) Start and Stop the mirroring endpoints 2) Set Partner Resume, in that order.

  • ALTER ENDPOINT Mirroring STATE=STOPPED
  • ALTER ENDPOINT Mirroring STATE=STARTED
  • ALTER DATABASE databasename SET PARTNER RESUME

If this does nothing, you may have to rebuild the mirror.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.