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 |
|
saurabh811
Starting Member
33 Posts |
 Posted - 2009-01-08 : 17:16:00
|
| Hi all,,well i have some issues with data replication in sql server 2005.i have two DB server A and B.i am replicating database temp from server A to server B using transcation replication method.i created publication for database temp on server A.now restore database temp on server B manually.now create subscriber for server B.before replication i check data in database temp on server B which i restored from server A.after creating everything -- publication,subscriber and distribution database on server A when i go back on server B and check into database temp there were no data in the database.but the original database temp on server A has all data.now i insert new data into database temp in server A. and go back and check server B..again no data.so what else should i check..for replication..m i missing anything ..i also check in replication monitor..and its sys error,,,TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054)...so how to reslove this issue...my both server allows remote connection...pls help me...thanks, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-09 : 09:42:12
|
| Its confusing.Can you explain in steps how did you imply replication? |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-01-09 : 18:53:43
|
| When you added the subscriber did you uncheck the option that says something like "data already exists on subscriber"?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
data replication in sql server 2005