Pull Merge - Subscription Expired

I have a subscription that has expired. I need to be careful to preserve
the data that resides at my subscriber. I have two weeks worth of data at
the subscriber that needs to be synchronized with the publisher. Any
recommendations on the best approach to get my subscriber back in sync?
Thanks
Tina
re-initialize your merge subscription. When you re-initialize it you will
get a prompt to upload the changes from the subscriber to the publisher.
This will ensure that these changes are not lost.
"Tina Smith" <tb.smith@.earthlink.net> wrote in message
news:OWNyJX9KEHA.1032@.tk2msftngp13.phx.gbl...
> I have a subscription that has expired. I need to be careful to preserve
> the data that resides at my subscriber. I have two weeks worth of data
at
> the subscriber that needs to be synchronized with the publisher. Any
> recommendations on the best approach to get my subscriber back in sync?
> Thanks
> Tina
>
|||Sounds good! I'm hoping the re-init can be done via the
sp_reinitmergesubscription stored procedure because I'm running MSDE at the
subscribers.
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:%234twWk$KEHA.3492@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> re-initialize your merge subscription. When you re-initialize it you will
> get a prompt to upload the changes from the subscriber to the publisher.
> This will ensure that these changes are not lost.
> "Tina Smith" <tb.smith@.earthlink.net> wrote in message
> news:OWNyJX9KEHA.1032@.tk2msftngp13.phx.gbl...
preserve[vbcol=seagreen]
data
> at
>

Publication w/o logreader agent. Is it possible?

Hi,
Is it possible to create a publication without creating a logreader agent at
the same time? I'm on MS SQL Server 2000 SP3a.
-- Many thanks, Oskar
Oskar - if you are talking about transactional replication, this is an
integral part of the functioning. I'm interested in why would you like to
avoid the logreader agent?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Yes, transactional is what I am talking about. I am interested in this
because I want to have development databases published but I do not want to
have any real replication going on there. This is needed because we must have
identical "change management" in development and production environments.
Looks like I have partly solved this problem by making each development
server a publisher and a distributor, and regenerating the publication from a
script. I even could do without the snapshot agent, but getting rid of the
logreader seems to be tricky, if not impossible.
-- Thanks, Oskar
"Paul Ibison" wrote:

> Oskar - if you are talking about transactional replication, this is an
> integral part of the functioning. I'm interested in why would you like to
> avoid the logreader agent?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Oskar,
don't know if this helps, but until the snapshot has run, the log reader
isn't moving any commands to the distribution database. To prevent it
parsing the transaction log you could simply stop it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||That's exactly what I did. I just don't like to stop it manually everytime
the development database gets refreshed - its job name and id changes at
every such refreshing.
-- Oskar
"Paul Ibison" wrote:

> Oskar,
> don't know if this helps, but until the snapshot has run, the log reader
> isn't moving any commands to the distribution database. To prevent it
> parsing the transaction log you could simply stop it.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
|||I'd add a piece of code at the end of the script which stops and disables
the job - that way you don't need to worry about it afterwards.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)