February 4, 2011 at 2:15 am
I have 2 SQL servers that are mirrored but unfortunately the mirroring was suspeneded over a week ago (unknown reason) trouble is I can't resume the mirror.
when I do resume the mirror it trys to synchronize but fails and suspends itself after around 30 seconds always with the same size of unrestored log - does this mean there is a bad part of the log?
screenshot here.
https://picasaweb.google.com/lh/photo/wM5d4WqFI2X3bZHWzFcyraRLFtpGBL1LkGBqxZcgAUE?feat=directlink
I don't want to break the mirror as I have a logshipping set up to another server which I can't break and believe this will happen if I take a full backup of the live database and restore it to the mirror....... am I in trouble?
any help would be greatly appreciated.
Thanks
February 7, 2011 at 11:22 am
Whenever I can not resume the mirroring session in SQL 2005, I had to re-set up the mirroring. Which did not break the log shipping. As long as you do not break the log chain (Truncating log), the log shipping will be fine.
February 10, 2011 at 4:15 am
Correct: log shipping should be fine (not touching the primary DB).
But you should to look at why mirroring won't resume, check the SQL ERRORLOG, server event logs etc (on both servers). Are there any other mirrored databases on that server? What is their current state?
Carlton.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply