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

setup replication in a log shipped database ( secondary database ) Expand / Collapse
Author
Message
Posted Friday, July 26, 2013 5:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 11, 2014 11:27 PM
Points: 24, Visits: 238
Hi ,
i have a server A as primary server , server B as secondary server ( log shipped in standby mode ) & i want to deploy a server C as a replication subscriber to server B. Is it possible ? considering that server ( database ) B would be in read only mode & not generating any Transaction logs .... what would the log reader agent be reading from Database B ? Please help , i need this information urgently
Post #1477946
Posted Friday, July 26, 2013 4:31 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 4:14 AM
Points: 234, Visits: 1,091
This topology isn't going to work / not possible.

How are you going to add a publication on server b for server c to subscribe to when its in standby mode ?

You'll need to add create a publication on server a and add server c as a subscriber to that.

Cheers

Vultar

Post #1478239
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse