November 2, 2009 at 8:58 pm
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.
Thanks,
S.
November 3, 2009 at 12:19 am
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?
S.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply