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 Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 49, Visits: 154
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.



Pradeep

Post #1396601
Posted Friday, December 14, 2012 6:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:05 PM
Points: 99, Visits: 98
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 Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 49, Visits: 154
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.



Pradeep

Post #1397648
Posted Tuesday, December 18, 2012 3:34 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:49 PM
Points: 37,722, Visits: 29,977
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 Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 49, Visits: 154
many thanks...

Pradeep.



Pradeep

Post #1397658
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse