April 26, 2009 at 12:28 pm
Hi
I am running MS SQL 2000 and set up a production server and a backup server for our application in our office. On the production server I created replication between my production server and backup server using transactional replication. Our production server is the publisher and distributor and our backup server is the subscriber for the replication process.
I am also writing a disaster and recovery plan for the office and is wondering if our production server crashes for any reason how can I make the our backup server the publisher and distributor and when we fix the production server make it the subscriber of the replication. Or do we have to recreate the replication between the two servers.
Kevin
April 29, 2009 at 10:09 am
Replication is not the best way to go for DR plan. Especially if you have Identity Columns and TimeStamp columns. If your DB does not have those kind of things, it is Ok to do that. You can make the Subscriber into your Main DB. You will just need to set up Distributor and the new Subscriber from the scratch again though.
-Roy
May 4, 2009 at 10:44 am
http://support.microsoft.com/?kbid=886839
HTH.
Vinay
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
May 4, 2009 at 10:51 am
There's no automated way. To make the subscriber the publisher you need to drop the subscription, set that server up for replication (creating a distributor) and then create the publication from scratch.
Why did you go for replication for DR?
Is the backup server used for anything (reporting?)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply