| Author |
Topic |
|
natishkc
Starting Member
29 Posts |
 Posted - 2009-01-29 : 01:00:23
|
| I am trying to do replication with transactional option. It is in LAN with 1GBS and both end having WIn2k3 with SQL2Ksp4.What are other measurment(s) to be there before proceeding.-Natish |
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-01-29 : 02:59:47
|
| Dear Giants,I tried it but synchronisation is not happening. is SA password requirwed for this?Pls provide me any url if anything related to this.-NatishNatish |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-29 : 10:35:59
|
| What is the error? |
|
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-01-30 : 08:23:27
|
| "Remote server is not available". I have started all RPC Services as well and normal network parameters are working fine (Pinging. file transfer etc)Natish |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-30 : 09:26:06
|
| I have never seen such a error. Did you search for how to step Tran Replication? There are lots of article regarding this. |
|
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-01-30 : 23:46:13
|
| I have done and gone through only. And now it is communicating. I have selected the transactional type. In the Replication -----> Subscritpion elements it is showing synchronisation is in progress. DB size is 5 GB and I have started before 12 hours. But updation not showing in the Subscription server Table as it is in the Publication server.Earlier error came due to some firewall protection.Natish |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-31 : 09:53:58
|
| Then you haven't configured correctly. Did Snapshot job completed successfully? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-31 : 23:33:33
|
| Here is what you need:http://www.mssqlcity.com/Articles/Replic/SetupTR/SetupTR.htm |
|
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-02-03 : 00:00:02
|
| Thanks a lotNatish |
|
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-02-04 : 03:51:14
|
| Dear sodeep,is it neccessary SA password must be there for Replication.Natish |
|
|
|
natishkc
Starting Member
29 Posts |
Posted - 2009-02-04 : 21:32:11
|
| Hi Giants,With great support from SQLTEAM Forum I have configured the Transactional Replication. In this regards any query pls mail me natishkc@yahoo.com.Once again Thanks to all Supportive MembersNatish |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 22:25:33
|
| Thanks. |
|
|
|
|
Replication with transactional