broken replication

Dear all
merry christmas and happy new year.
beacuse of virus my sql 2005/2008 replication is broken. i have a backup for
publication, distribution,subscribution. how can i restore my replication on
new sql server and if the subscribtion contains a new transactions that not
uploaded to publication, how can i uploaded it after rebuilding my broken
replication. i am using merge replication between windows 2003 sp2 servers
and windows xp.
Another problem: when i try to configure sql-server 2005 on windows XP as
subscriber to sql-server 2005 on windows 2003 SP2 using merge replication, it
will accept only pull replication and not accept push replication. how can i
configure push replication.

best regards and thanks
eng. thaar

You can't easily do this.

There are two options which might work.
1) Do a no-sync subscription and then use sp_addtabletocontents on your
subscriber to try to add the data back.
2) create a new subscription database and then deploy the subscription to
this new subscription database. Then run the table diff utility and use it
to update the publisher or subscriber with the missing data.

What error message are you getting when you try to create a push
subscription?

"thaar" wrote in message

> Dear all
> merry christmas and happy new year.
> beacuse of virus my sql 2005/2008 replication is broken. i have a backup
> for
> publication, distribution,subscribution. how can i restore my replication
> on
> new sql server and if the subscribtion contains a new transactions that
> not
> uploaded to publication, how can i uploaded it after rebuilding my broken
> replication. i am using merge replication between windows 2003 sp2 servers
> and windows xp.
> Another problem: when i try to configure sql-server 2005 on windows XP as
> subscriber to sql-server 2005 on windows 2003 SP2 using merge replication,
> it
> will accept only pull replication and not accept push replication. how can
> i
> configure push replication.
>
> best regards and thanks
> eng. thaar