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 12»»

A Transactional Replication Primer Expand / Collapse
Author
Message
Posted Friday, November 3, 2006 10:23 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, September 3, 2007 8:54 AM
Points: 102, Visits: 1
Comments posted here are about the content posted at temp


Regards,

Cláudia Rego

www.footballbesttips.com
Post #320394
Posted Monday, November 20, 2006 3:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 23, 2007 4:05 AM
Points: 97, Visits: 1
Claudia, Your primer is excellent. Very informative etc. One issue which I have been trying to overcome is, I have an archive database on the subscriber receiving transactions from a publisher. Next developers make a change to the schema at the publisher. I end up having to rename my archive database on the subscriber ( as I don't want to lose this data ) and re-snapshot the updated publication to yet another archive database. I haven't yet discovered any way of overcoming this. Again excellent article and thank you. Derek
Post #324210
Posted Monday, November 20, 2006 4:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 10, 2014 3:22 AM
Points: 310, Visits: 411

I am working on a problem of replication from Spain to UK and this article makes interesting reading...thanks go to the author

Derek: If you want a perfect copy of the database you should try "Log-Shipping".

Pro: perfect copy of your database is maintained on your archive server, including all schema changes + data.
Con: the archive database must be in ReadOnly mode (but isn't that the idea of an archive anyway?)

If you don;t want to pay for the Enterprise version of SQL2k then there is a DIY solution contained in MS Back Office Resource Kit v4.5...I have been using this to maintain a DR copy of our DB's here in the UK for over 6 months now without a glitch.

 




Post #324218
Posted Monday, November 20, 2006 8:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 23, 2007 4:05 AM
Points: 97, Visits: 1

We are running SQL Server 2000 (sp3a) on Windows 2003 clustered. We are just starting to use Log Shipping for Disaster Recovery. Basically shipping the logs across the MAN to another building and restoring there. To be honest I inherited the Archiving solution we have in place and as such had not thought of using Log Shipping. I'll certainly give it some thought. Without going into too much detail, we have a number of activities which take place at quarter end which may complicate things. But thanks very much for the input. Well worth discussing further here with our corporate DBA. Derek

Post #324318
Posted Monday, November 20, 2006 9:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 11, 2012 6:50 AM
Points: 7, Visits: 18
The link to how you fix the IDENTITY is not working. Eere is the correct link.

http://www.sqlservercentral.com/columnists/crego/repl/figure22.jpg

I would also recommend against "fixing" the IDENTITY in this maner. When you do this the table is complete rebuilt. Click the little script icon to see what it is doing. A better option would be to set it as IDENTITY NOT FOR REPLICATION and then add the schema option of 0x04 to your publications.

Bert
Post #324352
Posted Monday, November 20, 2006 1:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 8, 2009 7:22 PM
Points: 14, Visits: 115

Hi Claudia,

Great read!  I am interested in creating a replication and log shipping from the same database.  The replication will be used for reporting while log shipping is used for warm standby.  Currently we already implemented log shipping using home grown scripts.  Do you have any details on how to implement replication with log shipping running?

Thanks.

Post #324402
Posted Monday, November 20, 2006 1:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 8, 2009 7:22 PM
Points: 14, Visits: 115

Hi Claudia,

Great read!  I am interested in creating a replication and log shipping from the same database.  The replication will be used for reporting while log shipping is used for warm standby.  Currently we already implemented log shipping using home grown scripts.  Do you have any details on how to implement replication with log shipping running?

Thanks.

Post #324403
Posted Monday, November 20, 2006 2:56 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 26, 2013 3:02 AM
Points: 49, Visits: 102

Hi,

Great article!

A few comments:

1. Regarding the custom stored procedures, you can eliminate the need of them by changing the article properties, and selecting not to use sp's instead of insert/update/delete commands. This way you can skip messing up with the stored procs.

2. The identity can certainly be used at the subscriber if you select it "Not for replication". Same thing for check constaints, triggers etc.

Cheers,

  Meir.




Post #324447
Posted Thursday, November 23, 2006 7:38 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, September 3, 2007 8:54 AM
Points: 102, Visits: 1
I'm very happy with your feedback.
I hope it helps who is trying to setting up this type of replication.
About log-shipping i don't have experience on this.
Cláudia



Regards,

Cláudia Rego

www.footballbesttips.com
Post #325181
Posted Wednesday, April 11, 2007 7:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 16, 2007 2:58 PM
Points: 3, Visits: 1

new to tranactional replication.....

If the idea is to replicate the database, why doesn't it replicat all the tables, is there a way to replicate the ones without primary keys?

Post #357696
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse