October 23, 2002 at 1:58 pm
Can any body help me in finding the article about transactional replication . I need to set transaction replication in my current system.
Thanks
October 23, 2002 at 4:46 pm
BOL (Books Online) has a decent explanation and if you use the wizards in EM doing a basic transactional pub is not bad. I do suggest doing it with something simple like Pubs so you can build and tear down a few times before you try in production. Beyond that if you have specific questions please post under replication - we'll try to help.
Andy
October 23, 2002 at 5:20 pm
Thanks a lot.
I did setup transaction replication once using pubs database at home and it works fine. I have not setup at the client site yet. Now I got a chance to setup transactional replication.
May be you can help me in setting the plan first. I am going to make one server a Publisher and other server a Subscriber. Lets say Publisher get failed and application need to point to Subscriber because Subscriber has uptodate data.
Now Subscriber getting updated and Publisher is down, so when the Publisher is up and running we then move data from subscriber to Publisher because Publisher does not have a uptodate data.
So my question is when we setup a transactional replication , can we update a Subscriber if yes then , is there a way to Syncronize data from subscriber to Publisher.
I really appreciated any help.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply