reinitialize deleted data

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
jazper
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
"Jazper Manto" <ejazper@.hotmail.com> wrote in message
news:uy8gN83aFHA.2900@.TK2MSFTNGP15.phx.gbl...
> 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
> jazper
|||hi hilary
what is a "subscriber backup"?
is this the correct behavour of a reinitialize?
jazper

Re-indexing through clocks changing

I was planning to re-index my database (225GB) this coming weekend however I
have just realised that it will be running through the server clock changing
(advancing 1 hour). Will this have any adverse effect on the procedure?
GavNo problem. The only thing to be careful with is when you go back in time,
and you have transactions occurring during that time, you can find yourself
in a position where you cannot do point in time restore for transaction that
occurred during that hour.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Gavin Metcalfe" <gavin.metcalfe@.btinternet.com> wrote in message
news:c3n37r$l3p$1@.hercules.btinternet.com...
> I was planning to re-index my database (225GB) this coming weekend however
I
> have just realised that it will be running through the server clock
changing
> (advancing 1 hour). Will this have any adverse effect on the procedure?
> Gav
>