Monday, February 20, 2012

no sync replication instructions.

Hello.
Does anyone have instructions on how to set back up replication that has
been marked for re-initilization thru the gui (enterprise manager)? We
have a subscriber that had their wan link down for the whole weekend and
now all their publications are marked for reinitialization. Some the
tables in question are 20gb in size, and that is just too big for us to
re-do snapshots and send over a WAN link. So in reading Hilary's and
Pauls post it looks like a "no-sync" will help me not have to send over
a snap shot.
1. how do i do this through enterprise manager only?
2. is there anyway for me to tell replication to go back lets say the
last 48hrs for the tables that we replicate, and "repush" that data
over?
Thanks,
-comb
Comb,
this article should help:
http://www.replicationanswers.com/No...alizations.asp
Initially I'd use Redgate's DataCompare to sync the data for any stray
changes.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||In article <eo9dqUZrFHA.1256@.TK2MSFTNGP09.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> Comb,
> this article should help:
> http://www.replicationanswers.com/No...alizations.asp
> Initially I'd use Redgate's DataCompare to sync the data for any stray
> changes.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
Thanks Paul. I appreciate yours and hilary's help.
looking now. I am also going to look into this Redgates.
-comb

No comments:

Post a Comment