Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-06 : 09:09:49
|
| Ken Ng writes "I have 3 computers A ,B ,C having SQL 7.0 installed whichB is connected to A by leased line and C is connected to A by 56k modem .I'd like to replicate data from B to A using 'Transistion Replication' and it works . However , when I set up the replication setting from C to A . The 'transisional Replication' function is disabled . Why this occur ??At first I was informed that I may wrongly installed thw 'Desktop' version but I found that I correctly install the 'Standard' vesrionKen" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-07 : 01:33:52
|
| Do you perhaps have truncate log on checkpoint = true?-Chad |
 |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-05-07 : 05:28:05
|
quote:
Do you perhaps have truncate log on checkpoint = true?-Chad
Are you sure you are on Standard edition? Do you have a local distributor or remote distributor? Even if you have trunc. log on checkpt enabled, you should be able to set up transactional replication. Replicated transactions will not be truncated until they are distributed.--HTH,Vyashttp://vyaskn.tripod.com |
|
|
|
|
|
|
replication