Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

restoring databse in sql server replication

Status
Not open for further replies.

steelsink42

Programmer
Aug 13, 2001
1
MX
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top