SQL Server Developer Center > SQL Server Forums > Database Mirroring > Ex-Database Mirror Continues to Synchronize
Ask a questionAsk a question
 

QuestionEx-Database Mirror Continues to Synchronize

  • Tuesday, November 03, 2009 7:00 AMFal2216 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Hi All,

    Recently we decommissioned at old server on which we had out Mirror databases. We moved all the databases to the new server and reestablilshed mirroring.

    However, one of our databases remains in Synchronizing mode, with 0 unsent log, and remained in this state for a good couple of hours. Perhaps part of the problem is where Database Mirroring Monitor shows the removed/old mirror pair also as Synchronizing. As this caused other issues I removed the new mirror and left the database standalone.

    After this we rebooted the decommissioned server, then shut down and removed it from the network. We then rebooted the 'principle' server and reestablished mirroring. But we ge the same result: the new pair shows Synchonizing, and so does the old pair, even though old-mirror server no longer exists. It is worth mentioning that no other mirrored pair exhibited this behaviour.


    I'm at a bit of a loss how Database Mirroring Monitor is managing to send logs to a non-existant server, so I'm hoping someone has some ideas on how to resolve this issue.


    Thank.

All Replies