Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Switch a subscriber to a publisher Expand / Collapse
Author
Message
Posted Sunday, April 26, 2009 12:28 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 26, 2009 12:28 PM
Points: 1, Visits: 2
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
Post #704636
Posted Wednesday, April 29, 2009 10:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 14, 2014 12:37 PM
Points: 2,361, Visits: 6,752
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
Post #707009
Posted Monday, May 4, 2009 10:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:44 PM
Points: 1,537, Visits: 739
http://support.microsoft.com/?kbid=886839

HTH.
Vinay


Thanx.
Vinay


http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
Post #709508
Posted Monday, May 4, 2009 10:51 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 40,456, Visits: 36,912
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #709512
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse