January 31, 2010 at 9:17 pm
good day everyone,
Iam new with replication; i tried to create a snapshot replication between 2 instances using gui; however, i cannot copy the database tables from instance 1 to instance 2; everytime i refresh instance 2 it only shows the system tables. but not the tables i created in instance1; when i checked the replication monitor it gives me this status;
Publications status; Status ok
Subscription watchlist; uninitialize subscription
Common jobs;
Expired subscription clean up, replication monitoring refresher for distribution - never started
agent history clean, Expired subscription cleanup , distribution clean up, replication agent check up - Retrying failed command
It seems thats the subscrition is not connected to the publisher;
Thanks and let me know if you needed additional information,
February 1, 2010 at 1:54 am
for configuring replication table must have primary key created on it.
do ur table have it(primary key)?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
February 1, 2010 at 2:27 am
yes, it already have a primary key. but still not copying; thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply