question

ramesh 1 avatar image
ramesh 1 asked

sql server 2008 replication in standard edition

Hi want to configure replication, can you guide me to have prerequisits and step by step process, i want to replicate transactional replication
sql-server-2008replication
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image
Cyborg answered
Consider this [Designing and Implementing: Walkthroughs][1] [Tutorials][2] [1]: http://technet.microsoft.com/en-us/library/bb510630.aspx [2]: http://technet.microsoft.com/en-us/library/aa337475.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
Just a note about replication - it is not something to do blind via a step by step guide from the web. It can be quite a complicated beast to control and needs more than a wizard to replicate data with any sort of reliability in production. I suggest you read up on the replication mechanism as a whole and then take the next steps in setting up replication: - [How Transational Replication Works][1] - [Designing and Implementing Replication][2] The basics step are: - Setup a publisher (the server where data is being replicated from) - Setup a distributor (the server that handles moving the data from publisher to subscriber ***** ) - Setup a publication (group of db objects to replicate - tables, views etc.) - Setup a subscriber (the server(s) that will recieve the replicated data - Create the initial snapshot (at some point in time when the publisher will not feel the load) - Wait for publisher and subscriber to get in synch - Be amazed at the whole process actually working! There are many parts that I have missed out of the list above, but if you read up on replication first and try it out on a testbed, you will see how it all fits together. [1]: http://msdn.microsoft.com/en-us/library/ms151706.aspx [2]: http://msdn.microsoft.com/en-us/library/ms151847.aspx
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I believe, its equally important to understand replication monitor and Troubleshooting also..
0 Likes 0 ·
@Cyborg - definitely. I would hope that reading up on the architecture would lead ramesh to read up on monitoring and troubleshooting too.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.