Log Reader agent in Snapshot Replication -- sql server replication

Paul Ibison
9/14/2005 12:00:00 AM

John,
have a look for any transactional publications based on this database using
sp_helppublication.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

John
9/14/2005 7:56:01 AM

I saw Log Reader agent is working in Snapshot Replication Environment. is
this ture or diffrent set up of replication

i think we dont require Log reader agent for Snapshot Replication. please
advice

Thanks,

John
9/14/2005 8:26:11 AM

snapshot repliaction in description.
replication frequency is 1, 1 = Scheduled table refresh, yes.
i saw in books on line, there is no LR Agent for snapshot replication. or
whether it depends on dbo mode?

[quoted text, click to view]

Paul Ibison
9/14/2005 8:56:20 PM

John,
if there is definitely no transactional publication there, I'd disable the
log reader job for a while. It's possible somehow it is an orphaned job.
After a decent period (of no complaints etc) I'd delete the log reader agent
(job).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Log Reader agent in Snapshot Replication