question

Chitrarekha avatar image
Chitrarekha asked

Steps for transactional Replication

I am following the below url to build Transactional Replication. But this is a bit overwhelming for me. Can someone describe the steps that we should follow to build Transactional replication? I have one instance where I have all the databases and in case of failure of that server I would like to connect to a different server and have the application running.
sql-server-2008-r2
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.

Hi @Chitrarekha, Unfortunately the URL you reference has been lost from your post - can you detail what steps you have implemented, and where you have become stuck? If you can post the URL and advise where you're struggling to understand then we will be better able to help. Just as a first attempt at answering your question, have you seen the article http://www.sql-server-performance.com/2010/transactional-replication-2008-r2/ by Satnam Singh? Dave.
0 Likes 0 ·
Following is the url to setup and gather replication info http://www.sqlservercentral.com/stairway/72401/ However I will follow your url. I was also following the below link.http:// www.mssqlcity.com/Articles/Replic/SetupTR/SetupTR.htm
0 Likes 0 ·

1 Answer

· Write an Answer
ramesh 1 avatar image
ramesh 1 answered
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.

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.