all groups > sql server replication > june 2005 >
You're in the

sql server replication

group:

reinitialize deleted data


reinitialize deleted data Jazper Manto
6/7/2005 12:00:00 AM
sql server replication:
hi

i have sql 2000 sp3 and a merge publication with a filter. additional i
have a client with msde also sp3 with is subscriber to the
server-publication.

the replication worked just fine for weeks. on one day i made a sync
with lots of data. while synchronizing the computer shutdown into
standby. after waking up i had a error message from the sql server that
he lost connection or something. til here no problem. so i just tried
again to synchronize. i received the error "merge process could not
initialize publisher XXX"

so i clicked on "reinitialize" on the subscriber. he said then that he
would do it when the merge agent starts the next time. so i synchronized
again and it worked very fast. a bit too fast because ALL data in the
table he should have synchronized has gone. obviously deleted...

can i restore this data again without backup :-)
is this the correct behavour of a reinitialize??? if yes, what should i
have done else? if no, what happend then?

thanx for every hint
Re: reinitialize deleted data Hilary Cotter
6/7/2005 9:26:57 PM
You should be able to restore the subscriber from the subscriber backup.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Re: reinitialize deleted data Jazper Manto
6/9/2005 7:10:33 AM
hi hilary

what is a "subscriber backup"?
is this the correct behavour of a reinitialize???

jazper

AddThis Social Bookmark Button