Sunday 27 May 2012

Database Mirroring status is disconnected or synchronizing but no logs moving

Problem::
Database Mirroring status is disconnected or synchronizing but no logs moving.

Steps to Resolve::

Resume the mirroring.
Note :: Trying to resume mirroring from remote would not work all the times, So connect directly and resume it.

ALTER DATABASE <Database Name> SET PARTNER RESUME;

If no changes in mirroring state try to pause(suspend) and resume it.

ALTER DATABASE <Database Name> SET PARTNER SUSPEND;

ALTER DATABASE <Database Name> SET PARTNER RESUME;

If it fails with below error.
Msg 1447, Level 16, State 21, Line 1
ALTER DATABASE "Database Name" command cannot be executed until both partner server instances are up, running, and connected. Start the partner and reissue the command.
(OR)
Msg 1404, Level 16, State 11, Line 1
The command failed because the database mirror is busy. Reissue the command later.


Try to restart the endpoints(This should fix the issue)
use master
GO
alter endpoint endpoint_name state = stopped;
GO
alter endpoint endpoint_name state = started;
GO


If nothing works, restart the Mirror server SQL services. After restart if mirroring is in suspended state, resume it.

1 comment:

  1. What was that command, how did we resolve this? Ah, thats right... So simpo! LIFE SAVER FLAVOR: ButterScotchRipple

    ReplyDelete