Re: Internals question

Yes, for named subscriptions this is correct. For anonymous they hang around
till the end of your retention period.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Bob Castleman" <nomail@here> wrote in message
news:eLmggmKrFHA.2588@xxxxxxxxxxxxxxxxxxxxxxx
> According to Hillary's book, the table MSRepl_commands contains the
commands
> necessary to sync between publishe and subscriber. In my test database,
this
> is currently empty. This leads me to assume that these entries are deleted
> as the subcribers are fully synched. Is this correct? Also, how are these
> commands generated and placed into this table?
>
> Thanks,
>
> Bob Castleman
> DBA Poseur
>
>


.

Relevant Pages

  • Re: Internals question
    ... What actually generates the commands? ... for named subscriptions this is correct. ... > till the end of your retention period. ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: JOB stalls in a transaction replication
    ... Looking for a SQL Server replication book? ... When it starts delivering the commands, ...
    (microsoft.public.sqlserver.replication)
  • Re: replication transaction logs
    ... "Hilary Cotter" wrote: ... > However for named subscriptions these commands are removed every 10 minutes. ... >> How can I find the tables or files where the replication log is stored. ...
    (microsoft.public.sqlserver.replication)
  • Re: replication transaction logs
    ... However for named subscriptions these commands are removed every 10 minutes. ... Looking for a SQL Server replication book? ... "Lina Manjarres" wrote in message ...
    (microsoft.public.sqlserver.replication)
  • Re: sp mergemetadataretentioncleanup
    ... I am using Named subscriptions. ... > Looking for a SQL Server replication book? ... >> I'm testing automatic retention based cleanup. ... >> the publisher and subscriber, ...
    (microsoft.public.sqlserver.replication)