Ex-Database Mirror Continues to Synchronize

Question

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.

Answer 1

Hi All,

Some further information: changing the witness on the new pair also updates the witness on the old, non-existant pair.  Is there any way that SQL Server 2005 can retain a database servicing two mirrors?

Fal.

Answer 2

did you try removing the mirroring configuration by running SET PARTNER OFF and deleting the mirroring end points?

http://syntaxhelp.com/sqlserver/mirroring

---

Beyond Relational
SyntaxHelp.com