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

Transactional replication with updatable subscription Expand / Collapse
Author
Message
Posted Monday, November 5, 2012 7:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 4:09 AM
Points: 7, Visits: 85
Hi,

when setup transactional replication with updatable subscription we can see the linked servers created automatically. What is the role of each linked servers in replication.
Post #1381078
Posted Friday, November 9, 2012 10:10 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:57 AM
Points: 7,081, Visits: 12,575
The replication subsystem uses Linked Servers to communicate between Publishers and Subscribers.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1383326
Posted Saturday, November 10, 2012 7:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 4:09 AM
Points: 7, Visits: 85
thanks..
Is it only for immediate updating or for both immediate and queued updating??
Post #1383364
Posted Saturday, November 10, 2012 8:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:57 AM
Points: 7,081, Visits: 12,575
All types of replication subscriptions. When you run some of the replication configuration stored procedures these Linked Servers are used to communicate configuration changes between instances.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1383374
Posted Monday, November 12, 2012 4:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 4:09 AM
Points: 7, Visits: 85
Thanks a lot...

Got the point

If you have any link which describes the working of transactional replication with updatable subscriptions.. please share.
Post #1383607
Posted Monday, November 12, 2012 12:39 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:57 AM
Points: 7,081, Visits: 12,575
Sorry, I wish I had a more targeted referral for you but Updatable Subscriptions are not something I have specifically worked with in a production setting so the best I can do is refer you to Books Online and your favorite search engine.

Updatable Subscriptions for Transactional Replication (SQL Server 2012)


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1383821
Posted Monday, November 12, 2012 8:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 4:09 AM
Points: 7, Visits: 85
no probs..

Thanks a lot for all your informations
Post #1383928
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse