Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Transactional Replication Primer


A Transactional Replication Primer

Author
Message
Cláudia Sousa Rego
Cláudia Sousa Rego
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 1
Comments posted here are about the content posted at temp


Regards,

Cláudia Rego

www.footballbesttips.com
Derek Wallace
Derek Wallace
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
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
balde
balde
SSC-Addicted
SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)SSC-Addicted (414 reputation)

Group: General Forum Members
Points: 414 Visits: 597

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.

;-)





Derek Wallace
Derek Wallace
SSC Journeyman
SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)SSC Journeyman (97 reputation)

Group: General Forum Members
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


Bert Corderman
Bert Corderman
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
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
chung-327878
chung-327878
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 116

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.


chung-327878
chung-327878
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 116

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.


meird
meird
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
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.





Cláudia Sousa Rego
Cláudia Sousa Rego
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
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
Brian J. O'Neill
 Brian J. O'Neill
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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?


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search