September 9, 2014 at 1:05 am
Hello,
I hope someone can offer a little insight. I have read an article that outlines how to put log shipping on databases that are already mirroring, but due to a horrible twist of fate, I need to do it the other way round. The databases are already log shipped, and now I need to mirror the databases to another destination.
I'd love to hear from anyone who may have done this in the past, or can offer a bit of insight as to how I can go about getting it in, and avoid disruption to the log shipping process, and while that's going on, how would I apply the transaction log backup to the mirrored database to bring it into synch to start mirroring in the first place? There are no T-log backups other than those used by the log shipped databases. :hehe:
I'm working with SQL 2008 R2 Enterprise Edition.
Thank you for any help.
Regards,
D.
September 9, 2014 at 7:43 am
This link might help you.
September 9, 2014 at 11:06 pm
Hello,
Thank you for taking the time to answer my post, I had read the article previous to posting here, but in this case the Mirroring is already in place, and Log Shipping is getting applied.
Its say that it can be the other way around, but then doesnt cover that situation.
The part that perplexs me is this...If the databases are being logged shipped, and there is no independent T-Log backups (and even if there was, I am not sure how it would help me), how do I get the restored database (the mirror) up to synch with the principle using the transaction logs, with all the log shipping going on?
I have to assume that log shipping would have to be stopped, but will all the databases have to be made unavailable to get a T-log backup that I can use to get the Mirrored database up to synch to get the mirroring started? I'm also not sure what portion of the t-log I'd need to bring everything in line.
I would imagine its going to be tough to get an answer to this as I cant really see many people ever having been in this situation.
Regards,
D.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply