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

Replication configure in Log Shipping Database Expand / Collapse
Author
Message
Posted Friday, December 14, 2012 5:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Hi,

We have 5 databases in two different servers and its already configured in log shipping and its running successfully also. But now i want configure merge replication from those 5 existing databases. Is it possible to achieve?

Kindly advice me on this...



Pradeep
Post #1396601
Posted Friday, December 14, 2012 6:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 14, 2013 8:05 AM
Points: 101, Visits: 108
Yes it is possible but why you want to do that when the logshipping already been configured on the same databases?
Post #1396614
Posted Tuesday, December 18, 2012 3:24 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
Its for business requirements...

Eg:

1) Source database 'A' already configured log shipping to Destination database 'B' (Its working fine)

2) Same Source database 'A' need to be configure merge replication to other Destination database 'X' (This is requirement)

Source databases is same for both log shipping and merge replication.

Is it achievable?

Thanks...





Pradeep
Post #1397648
Posted Tuesday, December 18, 2012 3:34 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 @ 6:12 AM
Points: 42,755, Visits: 35,843
Sure it's possible. It's just going to be a normal merge replication setup.


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 #1397656
Posted Tuesday, December 18, 2012 3:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:44 AM
Points: 91, Visits: 322
many thanks...

Pradeep
Post #1397658
Posted Thursday, July 25, 2013 6:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 11, 2014 11:27 PM
Points: 24, Visits: 238
Hi ,
i have a slightly different situation , 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 #1477817
Posted Friday, July 26, 2013 2:18 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 @ 6:12 AM
Points: 42,755, Visits: 35,843
Please post new questions in a new thread. Thank you.


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 #1477900
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse