steelsink42
Programmer
hi
I'm using merge replication in sql server 2000, the replication is working well, but, i want to implement a backup schema, i made one from publisher database, the problem is:
step 1. backup publisher database
2 I made some changes to database dropping 5 records
3 the changes are replicated to subscribers
4 I restore the publisher database, the 5 records dropped are recuperated (only until merge agent is activated)
5 when merge agent is activated, the 5 records are droped again in the publisher database. but i don't want that, 5 records must be inserted in subscribers database.
I read the online books and they says that its possible, but i dont know how to sincronize publisher with subscriber and not subscriber with publisher.
thanks
I'll really appreciate your answering as soon as posible.
I'm using merge replication in sql server 2000, the replication is working well, but, i want to implement a backup schema, i made one from publisher database, the problem is:
step 1. backup publisher database
2 I made some changes to database dropping 5 records
3 the changes are replicated to subscribers
4 I restore the publisher database, the 5 records dropped are recuperated (only until merge agent is activated)
5 when merge agent is activated, the 5 records are droped again in the publisher database. but i don't want that, 5 records must be inserted in subscribers database.
I read the online books and they says that its possible, but i dont know how to sincronize publisher with subscriber and not subscriber with publisher.
thanks
I'll really appreciate your answering as soon as posible.