Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to SQL Server Replication - STEP 5: Transactional Replication & How it works Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 10:37 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 9, 2011 7:01 AM
Points: 15, Visits: 36
Comments posted to this topic are about the item Stairway to SQL Server Replication - STEP 5: Transactional Replication & How it works
Post #1063695
Posted Wednesday, July 20, 2011 7:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:02 PM
Points: 2, Visits: 28
Is it possible to dynamically pause or stop replication while publishing changes to the database being replicated, and then restart replication once changes are deployed? If yes, could you provide script example?
Post #1145006
Posted Friday, January 13, 2012 7:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 9:59 AM
Points: 11, Visits: 585
I have taken a Merge Replication subscriber database offline to move datafiles while the snapshot was being applied, and once bringing the DB back online and restarting the Synchronization job on the subscriber, it continued where it left off.
Post #1235636
Posted Wednesday, November 18, 2015 12:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 21, 2016 6:34 AM
Points: 2, Visits: 76
Hi All,

I configured the Transactional replication for one Article i.e SQL Table that has 1.5 million records and nearly 100 columns. So now i want to split 100 column to 50-50 with two tables(A and B) and each has a primary key. So at last i configured but all the records are going to one table i.e A.. So Please suggest me how to do this. Appreciate your help..Thanks in advance
Post #1737640
Posted Wednesday, April 13, 2016 12:46 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 22, 2016 12:27 PM
Points: 401, Visits: 746
In the Log-Reader Agent section... is there any effect on having the database set up as "simple log".. I am getting a sinking feeling that the log reader would not capture all the changes before the log dropped them.
Post #1777577
Posted Wednesday, April 13, 2016 12:49 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 22, 2016 12:27 PM
Points: 401, Visits: 746
if you are needing a Pull.. is there a way to tell when the data is now up to date, so that other jobs can now run? (that process the new data)
Post #1777578
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse