October 12, 2010 at 4:54 am
HI,
I have planned to implements the TRANSACTIONAL Replications on Live Server, But Once i start the replications , Database should be balance up to current Transactions
Please let me know , what are the Presteps I have to follow...
October 12, 2010 at 6:14 am
If you setup your replication to be initialized, the replication will take care of transfering all the data before starting to replicate transactions.
So you don't have anything to do to prepare (beside having a DB ready).
The initialization should be done by hand if the volume to replicate is too big and you have another manual way to synchronize both DBs.
October 13, 2010 at 7:39 am
For transactional replication, make sure that all table that you want to replicate have a PK.
You can initialize the subscriber with Snapshots or from Back up. Try to set the distributor in a separate server.
Also keep in mind that if you are doing snapshot, there should be a location where the Publisher can put the snapshot files. The same location should be available to Distributor and subscriber. make sure your agent service is running under a domain user and not local system.
-Roy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply