March 4, 2014 at 4:17 am
Hi all. I need to failover from live production server A to server B. However this server A is the primary server for:
a) transactional replication to server C (300 tables involved)
b) merge replication to server C (20 tables involved)
After fail over, we will swap the physical and SQL server name (using Sp_dropserver & sp_addserver) so that the name will remain as A after failover. My questions are:
1) Do I need to re-setup the transactional and merge replication from scratch or is there any other way to ensure the replications to server C are working well as before? Because re-setup will take a lot of time due to many tables involved (my superior will kill me)
2) If it is necessary to re-setup from scratch, is there any faster way to do so? As I know, re-setup will involve initialization which will cause server C (another live server) data to be unavailable too, please correct me if I'm wrong.
server A= Microsoft SQL Server 2008 (Enterprise Edition 32 bit)
server C= Microsoft SQL Server 2008 (Standard Edition 64 bit)
Please.. please.., help me asap. Thanks in advance!! Really appreciate your time!
March 4, 2014 at 8:35 am
I have never had to do this before, so I could be very wrong, but, based on my understanding of replication, you're going to have to rebuild the entire thing. You're not going to be able to simply fail it over from one machine to the other.
The fact that you're going to rename server B to server A (assuming I read that correctly) implies that maybe you could... temporarily disable publication from Server a, migrate over to server b, rename, ensure that replication publication is set up exactly the same way, turn it back on... But I'm guessing there are internal management bits that are going prevent a smooth migration like that from occurring.
Best thing to do, set up some test machines with a small database and try it out. See what goes wrong and why.
But, I think you're stuck.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply