December 15, 2014 at 5:08 am
I need to 'break' and re-establish a faulty mirror.
Log is quite big due to not correctly mirroring for a few days.
My plan is:
a) break mirror.
b) backup log - to truncate all these records that the broken mirror connection have kept 'active'
c) backup database
d) backup log (2)
e) copy my db & log (2) down to mirror
f) restore
g) re-configure.
Step b is ok isn't it? I don't need these records (unless I'm very unlucky & sql dies in between me breaking mirror & copying new backup down to mirror).
Appreciate a sanity check.
Thanks
December 17, 2014 at 5:49 am
snomadj (12/15/2014)
I need to 'break' and re-establish a faulty mirror.Log is quite big due to not correctly mirroring for a few days.
My plan is:
a) break mirror.
b) backup log - to truncate all these records that the broken mirror connection have kept 'active'
c) backup database
d) backup log (2)
e) copy my db & log (2) down to mirror
f) restore
g) re-configure.
Step b is ok isn't it? I don't need these records (unless I'm very unlucky & sql dies in between me breaking mirror & copying new backup down to mirror).
Appreciate a sanity check.
Thanks
Is the mirror instance now online?
can you connect to the mirror instance from the principal?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2014 at 8:12 am
Hi Perry,
Thanks for your reply(ies).
I'm not sure why this mirror failed to switch roles & back. But I've learned a few things along the way:
1) as soon as you break the mirror, checkpoint takes care of the the extra backed up tran log records so (b) above was unnecessary.
2) my mirror became 'orphaned' after I broke the mirror via SMSS on the principal. this only resolved itself after a restart of SQL on the mirror. not ideal. but from what i have encountered on google, not altogether uncommon either.
It's fine now, but mirroring is less robust than i had thought it to be.
roll on 2012.
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply