about log reader

Hi all Gurus
Will I have any problem for
stopping the log reader and then restarting it when the system clears up?
Thanks
As long as you don't leave it too long then it is ok. If you left it for
several days, you could find that when you start it, not all the commands
ultimately reach the subscriber. I was unfortunate to have this happen once
on an important system. This is because the distribution cleanup agent will
remove commands which exceed the transaction retention period, and each time
it runs, it'll delete some commands before the distribution agent can apply
them. So, it really depends on the transaction retention period you have and
how long it'll take to propagate the commands to determine how long you can
leave it.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:O$sIhwsPFHA.3156@.TK2MSFTNGP15.phx.gbl...
> As long as you don't leave it too long then it is ok. If you left it for
> several days, you could find that when you start it, not all the commands
> ultimately reach the subscriber. I was unfortunate to have this happen
once
> on an important system. This is because the distribution cleanup agent
will
> remove commands which exceed the transaction retention period, and each
time
> it runs, it'll delete some commands before the distribution agent can
apply
> them. So, it really depends on the transaction retention period you have
and
> how long it'll take to propagate the commands to determine how long you
can
> leave it.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>